Select Statement

Description of SELECT statement options, clauses and examples.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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.