SELECT
Last updated
Last updated
Spark supports a
SELECT
statement and conforms to the ANSI SQL standard. Queries are used to retrieve result sets from one or more tables. ()
This grammar is partially supported in Snowflake. Translation pending for these CREATE VIEW elements:
The WITH { CUBE | ROLLUP }
syntax is transformed to its CUBE(expr1, ...)
or ROLLUP(expr1, ...)
equivalent
Snowflake performs automatic optimization of JOINs and partitioning, meaning that hints are unnecessary, they are preserved as comments in the output code.
The AS
keyword is optional in Spark/Databricks, however in Snowflake is required so it is added.
LIMIT ALL
is removed as it is not needed in Snowflake, LIMIT with a literal value is preserved as-is.
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake
This clause is fully supported in Snowflake