Migrating to Snowflake? Here Is What You Need To Know

You’ve tried it out, and decided to make the move to Snowflake. But now what? Where should you start?

So, maybe you’re one of those companies who finally decided to take the leap and move to Snowflake, and now you’re looking at this “almost the same, but not really the same” technology and you’re not really figuring out where to start.

Prepare For The “Pay-Per-Use” Pricing Model

For all these reasons, it’s important that at least your heavier users understand how their usage impact costs, and to keep an eye on it for the first couple months.

Say Goodbye To Database Maintenance

Having nothing to tune can feel quite an odd for someone coming from an AWS Redshift cluster, but don’t be tempted, it’s very unlikely that you’ll do it better than Snowflake.

Moving The Data

Syntax Conversion (from Redshift)

Get Familiar With The Good Stuff!

Photo by Sanchez Amezcua on Unsplash

Understand the Snowflake Access Control Model

Understand How Warehouses Work, So You Can Use Them Optimally

* What if I suspend a warehouse while someone else is using it?

* What if I resize a warehouse while queries are in-flight?

* What if I have a query running in a small warehouse, can I resize the warehouse to make it quicker?

* Why wouldn’t I change warehouse size or suspend warehouses all the time? What are the downsides?

* Do Snowflake Warehouses always scale linearly (ie. double the warehouse size takes half the time to run a query)?

Photo by Markus Winkler on Unsplash

Get Used to Monitor Usage

Set Up Integrated Authentication If You Can

Don’t Overlook These Snowflake Configurations

A Final Word

Just a technical Data Architect having too much fun building new data platforms

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store