Skip to main content

Configure a Snowflake Pattern Data Connection

LiveRamp Clean Room’s Intelligence application on top of Snowflake streamlines data collaboration, delivering end-to-end solutions that drive business outcomes for brands. This integration combines LiveRamp Clean Room’s flexible UI with Snowflake's Data Cloud to orchestrate clean room use cases through low-code data connectors in order to access data at the cloud source with zero data movement.

To configure a Snowflake Pattern data connection, see the instructions below.

Overall Steps

Perform the following overall steps to configure a Snowflake Pattern data connection in LiveRamp Clean Room:

  1. Create the data connection.

  2. Map the fields.

For information on performing these steps, see the sections below.

Prerequisites

The LiveRamp Clean Room Snowflake CLI Framework must be installed prior to creating a Snowflake Pattern data connection. Installs are supported for both Mac and Windows. Perform the steps in the appropriate article:

Create the Data Connection

Once you've installed the appropriate Snowflake CLI Framework, create the data connection:

  1. From the LiveRamp Clean Room navigation pane, select Data Management → Data Connections.

  2. From the Data Connections page, click New Data Connection.

    data_cxn_new.png

  3. From the tiles that appear, select "Snowflake Data Connection".

  4. Select the Snowflake credential you created when you installed the Snowflake CLI Framework as part of the prerequisites.

  5. Configure the data connection:

    Note

    Database Name, Schema Name, and Table/View Name are case-sensitive and should match to your Snowflake account. LiveRamp Clean Room does not support recursive object dependencies (connection of tables or views requiring generation from different databases) by default.

    • Name: Enter a name of your choice.

    • Category: Enter a category of your choice.

    • Dataset Type: Select the type of dataset you are connecting (such as CRM Data or Ad Logs. If you are unsure, select Generic.

    • Database Name: Enter the database name from your Snowflake account.

    • Schema Name: Enter the schema name from your Snowflake account.

    • Table/View Name: Enter the name of the table or view from your Snowflake account.

  6. Review the data connection details and click Save Data Connection.

    Note

    All configured data connections can be seen on the Data Connections page.

  7. Upload your data files to your specified location.

When a connection is initially configured, it will show "Verifying Access" as the configuration status. Once the connection is confirmed and the status has changed to "Mapping Required", map the table's fields.

You will receive file processing notifications via email.

Map the Fields

Once the connection is confirmed and the status has changed to "Mapping Required", map the table's fields and add metadata:

  1. From the newly-created data connection, click Mapping.

    mceclip3.png

    The Map Fields screen opens and the file column names auto-populate.

    data_cxn_mapping_mapfields.png

  2. Click Next.

    Note

    Ignore the "Order", "Include", and "Delete" columns. They are not applicable for a Snowflake data connection setup.

    The Add Metadata screen opens.

    data_cxn_mapping_mapmetadata.png

  3. Select the data type for each column.

  4. If a column contains PII, slide the User Identifiers toggle to the right and then select the user identifier that defines the PII data.

  5. Click Save.

    Note

    Ignore the "PII" column. It is not applicable to a Snowflake Data Connection setup.

Your data connection configuration is complete and the status changes to "Completed".

In this section: