Connect to Snowflake as a Linked Server // ODBC

Did you know you can run queries against your Snowflake environment through SQL Server?

This is made possible by ODBC (Open Database Connectivity), which is a standard application programming interface for accessing database management systems.

By leveraging this standard, along with SQL Server's feature of creating a Linked Server, you can run commands against your Snowflake environment directly through SSMS.

Why would you do this?
- You have data stored in both places and do not want to copy data across servers (duplicates data)
- You are in the middle of a migration and still need access to both systems
- Just for fun

The best part of this setup is that it allows you to take advantage of all of the storage/computational benefits of Snowflake because the queries themselves are running on the Snowflake environment, not SQL Server.


►► The Starter Guide for Snowflake (Free PDF)
Simplify key Snowflake concepts & best practices so you can develop like a pro → https://bit.ly/starter-snowflake




Timestamps:
0:00 - Intro
0:06 Download ODBC Driver
1:10 Add ODBC Data Source
3:15 Create A Linked Server
6:34 Query Snowflake From SQL Server
9:27 Review Query History
10:00 Closing


Title & Tags:
Connect to Snowflake Through SQL Server as a Linked Server | ODBC | Snowflake Tutorial Tutorial
#kahandatasolutions #snowflake #dataengineering

• #education
• #analytics
• #data_warehousing
• #big_data
• #business_intelligence
• #education
• #snowflake_tutorial
• #snowflake_data_warehouse
• #data_architecture
• #snowflake_data_cloud
• #cloud_database
• #data_analytics
• #data_engineering
• #snowflake_computing
• #snowflake_architecture
• #data_transformation
• #data_warehouse
• #data_mining
• #edw
• #data_modeling
• #big_data
• #linked_server
• #odbc
• #sql_server
• #open_query
• #connect_to_snowflake_through_sql_server_as_a_linked_server