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)
)
请先登录再写评论。
We do have a bug for it mentioned here: https://youtrack.jetbrains.com/issue/DBE-20895/Highlight-PIVOT-including-other-function-parameters-correctly
Please subscribe to receive updates