Added by Cube: the engine's pivot of Distinct Value fails on the database (PLAN §11.12), and Snowflake's pivot takes only Count, Sum, Average, Min and Max, so not Median, Percentile, Std Dev, Variance or Join Text (§11.28)
Added by Cube: the engine's pivot of Distinct Value fails on the database (PLAN §11.12), and Snowflake's pivot takes only Count, Sum, Average, Min and Max, so not Median, Percentile, Std Dev, Variance or Join Text (§11.28)