I’ve spent the last seven years using Amazon Redshift, and during that time Snowflake became the standard modern data warehouse. (I did a survey of relevant companies’ data stacks when we evaluated Looker, and Snowflake was the overwhelming favorite warehouse.) Odds are pretty good that I’ll use Snowflake in my next job. So how will I go from training colleagues about efficient Redshift queries (and Introduction to SQL for interns) to writing Snowflake queries in the future?
I started with fairly obvious Google queries, “snowflake sql tutorial” and “snowflake sql query examples”, then added “query from redshift to snowflake” to find people’s comments about migrating. I knew what types of differences I was looking for:
- Structural differences in how data is stored/accessed
- Syntax differences
- Timestamps and dates – always painful
- Special capabilities / functions
Data engineering posts about migrating your warehouse are good for the first two; analytics and analytics engineering posts about advanced query tips are good for the third. Snowflake documentation and writing is good for filling in syntax details and expert advice once you know what to look for.Continue reading