[Limited Availability]{class="badge informative"}

Configure Snowflake for audience sourcing

Learn how to configure and connect your Snowflake Secure Data Share in the Adobe Real-Time CDP Collaboration UI to source audience data for activation and overlap analysis.

Overview overview

Snowflake is one of the supported options for sourcing first-party audience data into Collaboration. Other available methods include sourcing audiences from Experience Platform, connecting an AWS S3 bucket, or uploading a CSV file.

Follow the steps below to connect your Snowflake Secure Data Share and source your audience data into Collaboration. Once the setup is complete, you can review, activate, and manage your sourced audiences for your collaboration projects.

Prerequisites prerequisites

Before configuring your Snowflake connection, make sure you meet the following prerequisites:

Configure your Snowflake connection configure-snowflake-connection

From the My audiences tab within the Setup workspace, select the add icon ( ) and then select Audience.

If this is your first audience, you may also select the Add audience option.

The Add audience workflow appears. Select Add a new data connection and then select Next.

{modal="regular"}

Select Snowflake as the data connection select-snowflake

Next, select Snowflake as a data connection, followed by Next.

Review audience file review-audience-file

A dialog appears, explaining the requirements of the Snowflake Share and the Snowflake audience file before you can start sourcing. Make sure your Snowflake Share is created with the correct share name, account identifier, schema, and view. To confirm that your audience data is formatted and structured correctly for use in Collaboration, review the Audience Sourcing Specification guide.

Once finished, select Start onboarding.

Authenticate Snowflake Share connection authenticate-snowflake-share-connection

In this step, you need to provide the required Snowflake Share credentials to connect your Snowflake Share to Collaboration:

After entering all the required credentials, select Next.

A confirmation dialog appears at the bottom of the next page, confirming your Snowflake Share was successfully connected to Collaboration.

Provide name and description provide-name-description

In the Provide details view, enter a descriptive name and optional description for your Snowflake data connection. When finished, select Next.

Map fields map-fields

The Mapping screen is read-only at this time. You cannot add, delete, or apply transformations. Collaboration automatically maps source identity fields from your Snowflake Share data to target fields based on the Audience Sourcing Specification (v1.2).

Visually confirm the mapped fields and select Next to continue. You can also preview a sample data from your Snowflake Share with the Preview source data option.

When you choose to preview, the Snowflake Share data preview dialog appears with a sample data displayed in tabular format. Review this, then select Close.

Schedule refresh frequency and date range refresh-frequency-date-range

Next, in the Schedule view, use the dropdown menu to select refresh frequency between one and six days. Then use the calendar icon to specify start and end dates for sourcing audience.

Review and complete the connection review-and-complete

Finally, review your configuration settings in the summary screen. This view contains a summary of the following sections:

Select the pencil icon ( ) if you need to edit a section. Select Complete to confirm all sections.

A confirmation dialog confirms that the data connection was created successfully and audience sourcing is in progress.

Review sourced audiences review-sourced-audiences

After the setup is complete, Collaboration begins sourcing audiences from your Snowflake Share. If audience sourcing is in progress, a banner is displayed at the top of the view.

When the sourcing finishes, your audiences are available in the My Audiences tab with the same features and information as audiences sourced from Experience Platform.

When in grid view or table view, select a row item or View audience to see an overview of a specific audience. It displays the audience’s status, source, and data connection name, along with detailed panels for Identities, Categories, Connection access, and Metadata visibility. See how to view an individual audience for details.

Use this view to confirm audience configuration and visibility settings before using the audience in collaboration projects.

View your Snowflake data connection view-snowflake-connection

Your newly added Snowflake connection is immediately available in the My data connections tab. The audience source is displayed as Snowflake.

Your Snowflake data connection includes the same functionality and details as other audience data connections. Learn more about how to view and manage data connections.

Next steps next-steps

You have now successfully configured and connected your Snowflake as a data source in Collaboration. After sourcing completes, you can create collaboration projects, activate audiences, review overlaps and insights, and manage your audience settings and visibility.

For information about other audience sourcing methods, see the following documentations: