Скачать с ютуб Connect to Snowflake as a Linked Server // ODBC в хорошем качестве

Connect to Snowflake as a Linked Server // ODBC

Download The Modern Data Architecture Checklist (Free PDF) → https://bit.ly/kds-checklist OR Get 1:1 Guidance For Your Small (Or 1-Person) Data Team → https://bit.ly/kds-advising 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. 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