[Wranglers] Support for ANY keyword in the Snowflake’s PIVOT IN list

[Ali, Saqib]

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).
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20240510/9dafc2e2/attachment.htm>