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

IN -> Teradata_01.sql

SEL DISTINCT col1, col2 FROM table1

Snowflake

Select

OUT -> Teradata_01.sql

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

IN -> Teradata_02.sql

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

Snowflake

Alias

OUT -> Teradata_02.sql

SELECT
my_val,
sum(col1),
col2 AS my_val FROM
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.