Accessing Data from Snowflake

You can connect to and access data from Snowflake in Spotfire.

Prerequisites

Preparations

Before you start, read the System requirements for Spotfire Connectors. Make sure your version of Spotfire supports connecting to Snowflake. The system requirements page also specifies which ODBC driver, and versions of the driver, that you can use with the connector.

Installing the driver

To be able to connect to Snowflake in Spotfire, you must install the Snowflake ODBC driver.

For help with finding the right driver, see Drivers and data sources in Spotfire.

Setting up a DSN for your Snowflake data

To manage and create new connections to Snowflake, you must have a DSN for your Snowflake data on your computer.

For information and help, see How to use a DSN for connecting to Snowflake.

Only Snowflake DSNs that are configured with either of the following authentication methods are supported:

• Username and password (authenticator: snowflake)

• Native Okta (authenticator: https://<your_okta_account_name>.okta.com)

Tip: For more information about authentication and DSNs for Snowflake, see the official documentation from Snowflake.

Connecting to Snowflake

To connect to Snowflake, you have two options. Either you open and reuse a connection that is shared in your Spotfire library, or you can create a new connection based on a DSN.

Accessing data with an existing connection to Snowflake

You can access data from Snowflake by opening an existing connection or connection data source that is shared in your library. This is a convenient way to access a predefined selection of data from Snowflake, that you or someone else in your organization has set up.

1. On the Authoring bar, click Files and data .

2. In the Files and data flyout, browse the folders in the library, or start typing in the search field to find for your content.

   Tip: You can search for 'connector:snowflake' to find all shared connections and connection data sources that were created with the Snowflake connector.

3. Click to open the connection or connection data source that you want to add data from. If necessary, sign in with your Snowflake credentials.

   • If you opened a connection data source, use the controls in the Views in Selection dialog to select the data you want to analyze from the data source.

4. The final step is a summary view of the data that you are about to add to your analysis. Here you can view and change how the data should be added. Make any changes that you want, and then click OK to confirm and add the data to the analysis.

Creating a new connection to access data from Snowflake

If you want to create a new Spotfire connection to Snowflake, you must have a DSN for your data on your computer. You can use that DSN to create a connection in Spotfire. Once you have connected to Snowflake in Spotfire, you can share the connection or the analysis in the library, so that other users on your team can easily access the selected Snowflake data.

1. On the Authoring bar, click Files and data .

2. In the Files and data flyout, click Connect to.

3. In the list of connectors, select Snowflake, and then click New connection.

4. In the list in the Snowflake Connection dialog, select the DSN that you want to create a Spotfire connection from. Enter your Snowflake credentials, and then click Connect.  

5. In the Views in Connection dialog, select the data that you want to include in the connection, then click OK.

6. The final step is a summary view of the data that you are about to add to your analysis. Here you can view and change how the data will be added. Make any changes that you want, and then click OK to confirm and add the data to the analysis.

Note: Once you have created the connection in Spotfire, the DSN that you used to create the connection is no longer required for using the connection. All the required connection information, except for username and password, is stored in the Spotfire connection.