How to Migrate Data from Azure SQL to Snowflake

03-September-2021
In this episode, we’re going from cloud to cloud as we migrate some data from Azure SQL to Snowflake. We’ll use the pd_writer from the Pandas Tools addition to the Snowflake Connector for Python, and we’ll also use sqlalchemy, pyodbc, and some other great tech. pd_writer uses write_pandas, which is something we have covered in previous episodes, but the advantage is that it allows us to use some familiar Pandas syntax when we write to our database. This technique will be pretty efficient during the write process as it copies Parquet files to Snowflake behind the scenes. Let’s go!



Snowflake Project? Contact me today!