How Redshift-to-Snowflake migrations got so much easier
Migrating from Redshift to Snowflake sounds simple — until you actually do it.
A few years ago, I worked on a full Redshift-to-Snowflake migration project.
No tools. No automation. Just scripts, manual rewrites, and endless debugging.
We ran into all kinds of problems — from broken logic and performance issues to subtle differences in SQL behavior.
Even something as simple as how NULLs are sorted caused dashboards to show completely different results.
Fast forward to today — and it’s a totally different story.
In this video, I’ll walk you through:
• What that Redshift-to-Snowflake migration looked like back then
• The common pitfalls (like ORDER NULLS and function differences)
• How I would approach it today using SnowConvert
• How to validate data with HASH_AGG instead of custom scripts
• Why migrations are a perfect time to rethink architecture instead of copying it 1:1
If you’re a data engineer planning or supporting a Redshift-to-Snowflake migration, this will save you days of frustration — and maybe a few production rollbacks.
What you’ll learn:
✅ Common Redshift-to-Snowflake SQL pitfalls
✅ How SnowConvert automates most of the heavy lifting
✅ Why you still need tests and validation scripts
✅ Best practices for modern Snowflake migrations