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

Sel

SEL DISTINCT col1, col2 FROM table1

Snowflake

Select

SELECT DISTINCT col1, col2 FROM table1

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

Alias

SELECT
my_val, sum(col1),
col2 AS my_val FROM table1

Snowflake

Alias

SELECT
col2, sum(col1),
col2 AS my_val FROM MY_DW.table1

Removed clause options

The following clause options are not relevant to Snowflake, therefore they are removed during the migration.

Teradata	Snowflake
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.