Search code examples
sql-serverazuresnowflake-cloud-data-platformdata-transfer

Advice on Transferring data from Azure SQL server database to Snowflake

I am trying to transfer the reporting database from the Azure SQL server to Snowflake.

Would you please give me some tips and guide me on the best tools to automate this process?

Our Azure database updated every 1 hour, so I need to transfer the data and update it accordingly in Snowflake.

Thank you in advance for your guidance.

Solution

  • Here are 2 tools that have a free tier offering and support this use case:

    Matillion Data Loader: https://www.matillion.com/products/data-loader/

    StitchData: https://www.stitchdata.com/integrations/microsoft-azure/snowflake/