How to Migrate Data from MSSQL Server to Snowflake using Airflow!

preview_player
Показать описание
In this viewer request video, I'll show you how you can migrate data from an MSSQL Server Database to a Snowflake Database. If you have issues setting up the connection, please refer to my previous guide to connecting to MSSQL, because it sucks!

Рекомендации по теме
Комментарии
Автор

I have huge tables in my SQL server, so I am planning to extract data in batches and then load to S3 first and then load snowflake via snowpipe. I am also thinking of somehow making the job an incremental. Thank you for the video 🙏

karangupta_DE
Автор

Hi TheDataGuy, thank you for your videos. Why do you use an ODBC connector instead of a more traditional MsSqlHook (examples in the airflow github under ? Is it a windows thing or are there any advantages to using ODBC ?

lewischavas
welcome to shbcf.ru