Valid Snowflake PIVOT query is failing

Pivot is not that new, hence I don't understand why it's not supported? 

Query like that is going to fail:

 
  SELECT
    *
  FROM (
   SELECT
     *
   FROM sources.monday.items
   WHERE
     board_id = <id>
     AND column_type != 'formula'
  )
  PIVOT (
    MIN(value) FOR column_name IN(ANY)
  )