TD_UNPIVOT
Translation specification for the transformation of TD_UNPIVOT into an equivalent query in Snowflake
Some parts in the output code are omitted for clarity reasons.
Description
TD_UNPIVOT
in Teradata can unpivot multiple columns at once, while Snowflake UNPIVOT
can only unpivot a single column**.** The unpivot functionality is used to transform columns of the specified table into rows. For more information see TD_UNPIVOT.
The following transformation is able to generate a SQL query in Snowflake that unpivots multiple columns at the same time, the same way it works in Teradata.
Sample Source Patterns
Setup data title
Teradata
IN -> Teradata_01.sql
Snowflake
OUT -> Teradata_01.sql
TD_UNPIVOT transformation
Teradata
IN -> Teradata_02.sql
Snowflake
OUT -> Teradata_02.sql