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 and password

1. In the Connection Configuration screen, confirm the name of the data source.
2. Select an existing connection configuration from the drop-down list or create a new connection by clicking the + icon.
   To create a new connection, enter the following account details on the New Snowflake Connection Configuration screen. 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.
   • Username and Password: The username and password used to connect to your Snowflake database, schema, warehouse, and table or view.
3. Click Save.
4. In the Connection Configuration screen, click Establish Connection.
5. 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.
6. Click Continue.

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 list two columns, a timestamp column and a strictly incrementing column, to detect new and modified rows.
   • If you select Timestamp or Incrementing, you must list the name of one column to use to detect either new and modified rows or new rows only.
     For more information, see About Snowflake data source > Query modes.
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.