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
Snowflake
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
Snowflake
Removed clause options
The following clause options are not relevant to Snowflake, therefore they are removed during the migration.
Expand on
Unsupported
Normalize
Unsupported
With check option (Query)
Unsupported
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