[Analytics Engineering] Support for ANY keyword in the Snowflake’s PIVOT IN list
Ali, Saqib docbook.xml at gmail.com
Fri May 10 15:48:36 UTC 2024
A detailed blogpost by Qinyi Ding on Dynamic PIVOT in Snowflake: https://medium.com/snowflake/snowflake-supports-dynamic-pivot-e6cb58b71dd9
Saqib
On Wed, May 8, 2024 at 10:08 AM Ali, Saqib <docbook.xml at gmail.com> wrote:
Today Snowflake added support for the ANY keyword or a SUBQUERY in the> PIVOT IN-list. This is a huge time-saver. You longer have to hard-code the> values for the PIVOT column. Sample data and Query available in github:> https://qosf.com/snowflake-support-for-ANY-keyword-in-the-PIVOT-IN-list.html» I know that support for using a SUBQUERY in the IN-list has been around in> Oracle and Teradata for a while, but support for the ANY Keyword is unique> to Snowflake as far as I know (correct me if I am wrong).>
- Previous message (by thread): [Wranglers] Support for ANY keyword in the Snowflake’s PIVOT IN list
- Next message (by thread): [Wranglers] Using MATCH_RECOGNIZE in Snowflake to detect schema changes in source tables