How Compatible are Redshift and Snowflake’s SQL Syntaxes?

I just went through the process of converting 25,000 lines of SQL from Redshift to Snowflake. Here are my notes.

I've been working on this post for a while. It summarizes my experiences on a very successful project I wrapped up fairly recently. One of our clients was on a Redshift + dbt + Looker stack with a sizable Redshift installation, and I helped them transition from Redshift >> Snowflake. The results were impressive: concurrency, which was previously the biggest pain point, is just not a problem any more.

We're starting to see a lot of companies migrate from Redshift to Snowflake. If you're thinking about making the move, this post is worth the read. I haven't seen anyone else write about this process yet.


Want to receive more content like this in your inbox?