Connect to Snowflake database from SQL Server Linked Server

Updated: 04 Jan 2023


Progress DataDirect’s Snowflake ODBC Driver offers a high-performing, secure and reliable connectivity solution, for ODBC applications to access Snowflake data. If you want to connect Snowflake data from SSLS, Progress DataDirect has you covered. In this tutorial, you will learn how to configure the DataDirect Snowflake driver within SSMS (SQL Server Management Studio). These steps can also be used to configure any ODBC connection. 


SQL Server Management Studio is an ideal environment for managing the infrastructure of the SQL Server database and SQL Server itself. With SSMS, you can easily connect to your SQL Server instance, configure, and monitor database objects, as well as execute queries. Besides this, there is a possibility to create an ODBC connection to external data from SSMS. 


Thus, you can work with other databases and clouds used by your applications. 


In this article, we will describe a step-by-step procedure for establishing a connection to Snowflake from SSMS using our ODBC Driver for Snowflake 


Configure Connection to Snowflake ODBC Driver Using the ODBC Administrator

1. Download and install the Progress DataDirect ODBC driver using the 15-day trial software. In this tutorial, we are connecting to Snowflake Database. 


2. After the DataDirect Snowflake ODBC driver has been installed, open ODBC Administrator to configure the connection. Go to System DSN and click on Add.    




3. Choose the “DataDirect X.X Snowflake” and click on “Finish.”   





4. The ODBC Snowflake Driver Setup window will pop up.  





Enter your credentials, click on “Apply” and then click on “Test Connect.”     


5. The Snowflake Logon screen will pop up. Provide logon credentials and click on “OK.”    





6. A dialog box will confirm that the connection is established.     




Configure the DataDirect ODBC Snowflake Driver with Microsoft SQL Server Management Studio.

1. Launch SQL Server Management Studio. 


2. Navigate to Server Objects > Linked Servers > Providers > MSDASQL > and confirm that the Allow inprocess and Non transacted updates options are Enabled. 


Graphical user interface, application

Description automatically generated


3. In the object explorer navigate to Server Objects > Linked Servers. Right-click and select New Linked Server. 


Graphical user interface, application

Description automatically generated 


4. Fill in all the details. 

  • Name your linked server. 
  • Check the Server type as another data source. 
  • Select provider as Microsoft OLE DB Provider for ODBC Drivers from the drop-down menu.  
  • Enter the Product name as DataDirect.  
  • Enter the Data Source name created in the ODBC configuration process.  



5. Click on the Security page and select “Be made using this security context”. Then enter your Snowflake username and password. 


A screenshot of a computer

Description automatically generated 


6. Click on the Server Options tab and ensure that they match the following options shown in the following screen capture. 


Graphical user interface, application

Description automatically generated 


7. That’s it! You’re all done! Now you can find Snowflake in the provider's list. Navigate to Snowflake > Catalogs > default > Tables. You should see your tables now and be able to query your Snowflake data from the linked server.




Get started today with a free 15-day trial of Progress DataDirect Snowflake ODBC drivers, and connect to Microsoft SQL Server Management Studio. 

Contact Us for assistance with any questions you may have, and we will be happy to help!  


Connect any application to any data source anywhere

Explore all DataDirect Connectors

Need additional help with your product?

Get Customer Support