CODEWITHSUNDEEP
sql-serveramazon-web-servicessnowflake-cloud-data-platform
Ubaid Imran
Ubaid Imran

Reputation: 3

Export tables from Snowflake to SQL Server (AWS)

I am new to Snowflake, I need to export some tables from our Snowflake DW to SQL Server which is hosted on AWS Cloud. and can we automate it like a daily Job somewhere to fetch realtime data from Snowflake? can somebody guide me with the steps needed for this?

Upvotes: 0

Views: 1869

Answers (1)

Allen
Allen

Reputation: 426

The easiest way - without buying a third party tool - might be a SQL Server linked server to Snowflake. The steps are documented: https://snowflakecommunity.force.com/s/article/how-to-set-up-a-linked-server-from-sql-server-to-snowflake

Once you've setup the linked server a recurring SQL Server agent job can run the pull.

Upvotes: 1

Related Questions