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.

• Database name

• Database schema

• Connection user

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:
   • 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.
   • Database Name: The name of the Snowflake database to connect to.
   • Database Schema: The name of the Snowflake database schema to connect to.
   • Connection User: The username used to connect to your Snowflake database, schema, warehouse, and table or view. This role must have USAGE privileges. For more information, see Snowflake: Custom roles and Snowflake: Access control privileges.
3. Click Save.
4. In the Connection Configuration screen, enter your Snowflake account password and then 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. Toggle on Enable Processing if you want the Snowflake data source to begin processing immediately.
7. Click Next.

Step 2: Select query setting

In the Query Settings screen, select the appropriate query mode for your Snowflake table or view.

When 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. If you select Timestamp + Incrementing you must list two columns, a timestamp column and a strictly incrementing column, to detect new and modified rows.

For more information, see About Snowflake data source > Query settings.

When you are done, click Next.

Step 3: Configure the SQL 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 Back to 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.

4. Click Next.

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.

If the column contains a date/time value, select the corresponding attribute and click Set Format. In the Date/Time Format slideout, select the appropriate date/time format or enter a custom format and click Done.

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 Next.

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 Back to return to the step where you want to make changes.

1. View the event attribute and visitor ID mappings.
2. Click Create 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, query, and mapping configurations.