Lesson lm: Connect to Snowflake from Excel Using ODBC

Connect to Snowflake database from Excel using the Snowflake ODBC driver
1. Download and install ODBC Driver: developers.sno...
2. Add a new 64 ODBC DSN using the windows ODBC Data Sources tool
3.
Name: anything you like, eg FAD
Server: Get this from Accounts in Admin folder in your Snowflake account. Three dots on the right to view URLs. Copy the URL, without the bit
Tracing: 6
5. Over to Excel
Data Tab - Get Data - From other sources - From ODBC
Choose the DSN you just made.
6. Select the database and from in there, select the view.table you want
7. Click Load
8. The data will appear in a new sheet. Whenever you click Refresh All from the data tab, that data will refresh.
9. You will want to make a dynamic named range that grows as he data grows. See here: learn.microsof...