How to connect to Snowflake and retrieve data into Exploratory Desktop
Prerequisite
ODBC Driver
First, download and install the ODBC driver from Snowflake's web site.
For information on installing and configuring ODBC, please refer to the following document
Create a connection
Open the project and select Data Connections from the hamburger menu.
Click "Add."
Select the Databases tab and click on Snowflake.
Enter the host, warehouse, database, user name, and password, and click "Test Connection" to confirm the connection. If the connection is successful, give the connection a name of your choice and click "Add" to save.
!
Importing data
Click the plus (+) button to the right of the data frame and select Database data.
Select Snowflake.
Enter the SQL query and click "Run" to see the preview results. Click "Save" to import the query results.
When the import is complete, the summary view will appear as follows.
