Select Statement
Description of SELECT statement options, clauses and examples.
See Select statement
Snowflake supports Teradata's SELECT
syntax with a few exceptions. Primarily, it does not support the SEL
abbreviation.
Teradata
IN -> Teradata_01.sql
Snowflake
OUT -> Teradata_01.sql
Teradata supports referencing an alias before it is declared, but Snowflake does not. The transformation for this scenario is to take the referenced column and change the alias for the column name it references.
Teradata
IN -> Teradata_02.sql
Snowflake
OUT -> Teradata_02.sql
Removed clause options
The following clause options are not relevant to Snowflake, therefore they are removed during the migration.
Known Issues
1. SEL abbreviation unsupported
The abbreviation is unsupported in Snowflake but it is translated correctly by changing it to SELECT.
Related EWIs
No related EWIs.
Last updated