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
SEL DISTINCT col1, col2 FROM table1

Snowflake

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

IN -> Teradata_02.sql
SELECT
my_val, sum(col1),
col2 AS my_val FROM table1

Snowflake

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.

No related EWIs.

Last updated