Using Snowflake SQL
Getting familiar with our SQL dialect.
If you're familiar with common SQL dialects like Postgres or MySQL, you'll find that while there are a few specific differences, the basics will be very familiar, as the Snowflake SQL dialect is ANSI SQL compliant. (More on SQL standards and interoperability.)
- Filtering in Snowflake must be done with CASE statements.
- No support for DISTINCT ON, so people use window functions, generally.