Follow the steps below to set up a connection to Snowflake for your new application:
- Click the Data icon on the left panel.
- Click Connections. In the Connections section, click +New Connection. A popup will appear that displays all the data source types that your Analytics application can ingest.
- Browse through the connection types and click on the connection type you want to use - here, Snowflake.
- Click the edit icon near the top-left corner next to Unnamed Connection and enter a name for the connection. You can also add a description (optional) and choose a folder for your connection.
- Configure the required fields and warehouses for the chosen connection type. Analytics allows you to configure two different warehouses for unsampled and sampled queries thus providing cost efficiency. These warehouses are configured within your snowflake account. The fields are listed below:
| FIELD | DESCRIPTION |
| Account URL (Required) | JDBC formatted URL or any standard format URL associated with your Snowflake account. For example, jdbc:snowflake ://<account-id>.snowflakecomputing.com |
| Username (Required) | Snowflake account username. |
| Password (Required) | Snowflake account password. |
| Warehouse | Name of the default warehouse that is allocated to Analytics. This field is optional. |
| Sampling Warehouse |
Name of the warehouse allocated to Analytics for sampling query execution. This field is optional. |
-
- Click the refresh icon next to Health to test the connection's configuration. If the connection is healthy, icon turns green and Good is displayed. This means that the connection is properly configured and you can begin to ingest your data into Analytics.
- Click Save to save the connection. The saved connection will become enabled by default.
Your Snowflake account ID can be fetched from the URL of your Snowflake application.
Please sign in to leave a comment.