Manage a Snowflake data source

To allow Tealium to poll data from only the selected Snowflake tables or views, create a custom Snowflake role with USAGE privileges for the database, schema, warehouse, and table or view you want to connect to. For more information, see Snowflake: Custom roles and Snowflake: Access control privileges.

Complete the following steps to create a Snowflake data source:

1. In Tealium, go to Sources > Data Sources.
2. Click +Add Data Source.
3. Under Categories, click Data Warehouse and select Snowflake.
4. In the Name field, enter a unique name for the data source related to your use case.
5. Click Continue.

Step 1: Establish a Snowflake connection

The Snowflake data source lets you create connections to Snowflake that you can reuse in other Snowflake data sources.

Ensure you have the following Snowflake account information before you get started:

• Account identifier

  To determine the format of your account identifier, navigate to your Snowflake workspace and copy the unique account URL. For example, if your Snowflake account URL is
  xy12345.us-east-2.aws.snowflakecomputing.com/console#/internal/worksheet
  use the xy12345.us-east-2.aws.snowflakecomputing.com portion as your account identifier. For more information, see Snowflake: Account identifiers.

• Connection warehouse

• Database name

• Database schema

• Connection role

• Snowflake username

On the Connection Configuration screen, confirm the name of the data source, then select an existing connection from the drop-down list or create a new connection by clicking the + icon.

To configure a new connection, enter the following connection details. Depending on your Snowflake account settings, connection information may be case sensitive.

• Snowflake Connection Configuration Name: Provide a name for the reusable connection configuration.
• Account Identifier: The Snowflake account identifier without the http:// prefix in the following format:
  • Using a Snowflake account name: ACCOUNT_NAME.snowflakecomputing.com.
  • Using a Snowflake account locator in region: ACCOUNT_LOCATOR.CLOUD_REGION_ID.CLOUD.snowflakecomputing.com.
• Connection Warehouse: The name of the Snowflake warehouse to use for this connection.
• Database Name: The name of the Snowflake database to connect to.
• Database Schema: The name of the Snowflake database schema to connect to.
• Connection Role: The role assigned to the user in Snowflake. This role must have USAGE privileges. For more information, see Snowflake: Custom roles and Snowflake: Access control privileges.
• Authentication Method:
  • Key-Pair:
    1. Enter the username of the user with access to your Snowflake database, schema, warehouse, and table or view.
    2. Generate a key-pair using one of the following encryption algorithms: RSA-2048, RSA-3072, RSA-4096.
    3. Download the public key file. The key is only the text between the lines -----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY-----.
    4. Assign the public key to the user in Snowflake with the following command:

       ALTER USER example_user
       SET RSA_PUBLIC_KEY='your_public_key';
       

       For more information, see Snowflake: Assign a public key to a Snowflake user.
    5. Copy the key fingerprint if you want to verify that the key was assigned to the user correctly by following instructions at Snowflake: Verify the user’s public key fingerprint.
  • Username and Password (legacy): The username and password for the service user with access to your Snowflake database, schema, warehouse, and table or view. This option is only supported for existing connections. For more information, see Authentication.

Click Save to return to the the Connection Configuration screen, then click Establish Connection.

After you successfully connect to Snowflake, select the data source table from the Table Selection drop-down list. To import data from multiple Snowflake tables, create a view in Snowflake and select it from the drop-down list. For more information, see Snowflake: Overview of Views.

Step 2: Enable processing

Toggle on Enable Processing if you want the Snowflake data source to begin processing immediately after you save and publish your profile.

When you are done, click Continue.

Step 3: Configure the query

In the Query Mode and Configuration screen, select the appropriate query mode for your Snowflake table or view and optionally include a SQL WHERE clause to process only those records that match your custom condition.

1. Select a query mode.
   The query modes determine which column(s) in your Snowflake table or view will be used to detect new and/or modified rows.
   • If you select Timestamp + Incrementing (recommended) you must select two columns, a timestamp column and a strictly incrementing column, to detect new and modified rows.
   • If you select Timestamp or Incrementing, you must select a column to use to detect either new and modified rows or new rows only. For more information, see About Snowflake data source > Query modes.
     For the Timestamp + Incrementing and Timestamp modes, the selected timestamp column must be one of the following Snowflake data types: TIMESTAMP_LTZ, TIMESTAMP_TZ, or TIMESTAMP_NTZ. For more information, see the Snowflake: Date & time data types.
2. Configure the query.

   1. In the Query > Select Columns section, select the table or view columns to import to Tealium. To change the Snowflake table or view, click Previous and return to Step 1: Establish a Snowflake connection.

   2. (Optional) To add custom conditions or additional filters, include a SQL WHERE clause.

      The WHERE clause does not support subqueries from multiple tables. To import data from multiple Snowflake tables, create a view in Snowflake and select the view in the data source configuration. For more information, see Snowflake: Overview of Views.

   3. Click Test Query to validate your SQL query and preview the results.

3. Click Continue.

Step 4: Map columns

Use the column mapping table to map pre-configured column labels to event attributes or manually enter the column labels for mapping. Each row from Snowflake is processed as an event. Columns not mapped to an event attribute are ignored.

For each column label, select the corresponding event attribute from the drop-down list.

When you are done, click Continue.

Step 5: Map visitor ID attributes

To use your Snowflake data with AudienceStream, map your data to visitor ID attributes. Select the mapped event attribute that represents a visitor ID and map it to the corresponding visitor ID attribute.

Visitor ID Mapping in AudienceStream is enabled by default. Disabling visitor ID mapping may cause errors in visitor stitching. For more information, see Visitor Identification using Tealium Data Sources.

When you are done, click Continue.

Step 6: Summary

In this final step, view the summary, make any needed corrections, and then save and publish your profile. To edit your configuration, click Previous to return to the step where you want to make changes.

1. View the event attribute and visitor ID mappings.
2. Click Finish to create the data source and exit the configuration screen. The new data source is now listed in the Data Sources dashboard.
3. Click Save/Publish to save and publish your changes.

To check the status of import activity, navigate to the Data Sources dashboard and expand the data source.

Edit a Snowflake data source

To change a Snowflake data source, navigate to the Data Sources dashboard and click the edit icon next to the configuration you want to change. From the Edit Connection screen, you can edit Snowflake connection, processing settings, query, and mapping configurations.