PIVOT
Translation specification for the PIVOT function form Teradata to Snowflake
Some parts in the output code are omitted for clarity reasons.
Description
The pivot function is used to transform rows of a table into columns. For more information check the PIVOT Teradata documentation.
Sample Source Patterns
Setup data
Teradata
IN -> Teradata_01.sql
Snowflake
OUT -> Teradata_01.sql
Basic PIVOT transformation
Teradata
IN -> Teradata_02.sql
Snowflake
OUT -> Teradata_02.sql