Query Snowflake with Excel

Data

Query Snowflake with Excel

Kicking off a new year of Snowflake blogs seemed like a great opportunity to give you the tips and tricks of connecting to Snowflake from Excel. Businesses have been using databases to get data for Excel workbooks forever, but looking through the depths of Google, there wasn’t a comprehensive step-by-step guide on how you could do the same with Snowflake.

Follow these steps to pull data from Snowflake into Excel.

Prep

Prior to downloading any driver from the Snowflake UI, I’m going to check the version of Office 365 installed on my machine so that I know which version of the ODBC Driver to install. You can go into the settings of Excel and get this information by following these steps:

  1. Open the workbook.
  2. File > Account > About Excel:

getting Excel info for Snowflake query

Download the Driver

Now that I know I have the 32-bit version of Office 365 installed, I’m going to go and download the 32-bit ODBC Driver from the Snowflake UI.

  1. Navigate to the Snowflake UI, select the Help drop-down menu and go to Downloads.

Excel to Snowflake

2. Download and install the ODBC Driver:

installing ODBC Driver from Snowflake

Configure the ODBC Driver

Now that I have the correct version of the ODBC Driver for Snowflake installed, I am one step closer to connecting to Snowflake with Excel. The final steps are configuring my ODBC Driver into a Data Source Name (DSN).

  1. Navigate to the ODBC Data Source Administrator and add a User DSN. From the list of Drivers, select SnowflakeDSIIDriver:

ODBC data sources in Snowflake

  1. Fill out the relevant fields:
    • Data Source name
    • User
    • Server
    • Warehouse
    • Role

relevant fields to add a user DSN

Connecting with Excel

After configuring my ODBC Driver, I can start connecting to Snowflake with Excel. I am going to start by opening an Excel workbook. To set up the connection in the workbook, follow the instructions below:

  1. Select the Data tab.
  2. Select the drop-down for Get Data.
  3. Select the option for From Other Sources.
  4. Select the option From ODBC.

set up connection between Snowflake and Excel      5. Select the DSN we configured. Mine is called Snowflake.
      6. Select the database and table you want to query and enjoy!

Final Product

queries and connections between Snowflake and Excel

Above: Excel querying public FAA Flight data from Snowflake with the ODBC Driver

data layout in Excel

Above: Data layout in Excel

More About the Author

Holt Calder

Data Engineer
Using the Matillion API Query Profile After last week’s Airtable post, I’m sure all of our readers have been anxiously sitting on the edge of their seats. By now, I hope ...
Cloud-Based Data Collection with Airtable Welcome, diligent readers of the InterWorks blog. Today, I am kicking off a great two-part blog. Internally, we have been tossing ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072