Resonate Append File Transfer – Snowflake Setup and Delivery (Legacy for HEMs or MAIDs)

Please note, this article is to support existing Resonate Append clients using HEMs or MAIDs. We are transitioning all existing clients to which this applies to an improved sharing and delivery process. You can use this article as a reference if you have not yet transitioned. If you haven't yet transitioned, please reach out to your Customer Success Manager or contact resonatesupport@resonate.com to learn more and get started. 

There are various ways in which you can send and receive data via Snowflake. These steps cover the most preferred method by Resonate, which is to share your data with us in Snowflake via Data Sharing of a table (not a view). Please get in touch with your Resonate Customer Success Manager if you prefer a different option.

Important Notes:

• These steps use the “data sharing” option in Snowflake (vs the cleanroom option) to share the data back and forth
• These steps assume your Snowflake account is in the Amazon Web Services (AWS) US-East-1 Region 
  • If thats not the case, please follow Snowflake’s guidance to create a new database in Amazon Web Services (AWS) US-East-1 Region and then follow the process below.

Overview

Overall, there are 5 steps you’ll follow to share and receive Resonate Append data via Snowflake:

1. Confirm your Resonate Data Append attribute and/or cluster selection
2. Create a table using the Resonate prescribed format in your Snowflake account
3. Share the data table with Resonate
4. Resonate processes the data within the agreed upon SLA
5. You receive the deliverables from Resonate via your Snowflake account.
   • Output table shared with your Snowflake account
   • Definition and Summary files from Resonate customer success

*Repeat steps 1–5 for each Data Append refresh

Detailed Steps

Step 1: Confirm Your Resonate Append Attribute and/or Cluster Selection

1. Work with your Resonate Client Success Manager to select the Resonate Append attributes or clusters that include attribute values which fulfill your business needs.
2. The Resonate Client Success Management team will happily guide you through the Attribute and/or Cluster selection process.
3. Finalize your attributes and/or clusters and make sure your Resonate Client Success Manager is aware of your selections.

Step 2: Create a Table in Your Snowflake Account

1. In your Snowflake account, create the table of the IDs that you want to enrich via Resonate Append
2. The table must be created using the Resonate prescribed format as detailed below
   • Resonate accepts multiple types of IDs: Hashed Email (HEMs) and Mobile Ad IDs(MAIDs). Please see below for the full list and confirm that you have one of the following.
     • HEMs
       • MD5 (preferred)
       • SHA-1
       • SHA-256
     • MAIDs
   • The Table must contain
     • Column 1 Header: ID Type
     • Column 2 Header: ID
   • Once you have your two columns with headers, follow the instructions outlined below to fill out the information needed for each column.

For example:

Step 3: Send the Data to Resonate

1. Share the data with Resonate.
   • In Snowflake, navigate to Data sharing › External sharing
     ●    Select the “Shared by your account” tab:
      

• Click on “Share” and select “Create a Direct Share"

• Select the Data Table you want to share and click Done

• Add “HDB08375” in the Add accounts & click “Create Share”
  • NOTE: Snowflake is able to find HDB08375 ONLY when your account is in Amazon Web Services (AWS) US-East-1 Region 

At this point you have successfully shared the data with us!

Step 4: Resonate Will Process the Data

Resonate will process the data and create an output table for you in the expected SLA timeline. Please contact your Resonate Client Success Manager and let them know that the data has been shared.

Step 5: You will receive 3 deliverables from us

1. Output Table - your Resonate Client Success Manager will notify you once the output table is shared with you
   • In Snowflake, navigate to: Data sharing › External sharing on the Snowflake account you initially shared the table from.
   • Select the “Shared with you” tab
   • You will notice a new Share from Resonate.
   • Click on "Get Data" to create a database from the Share. The file should look like this:
2. Key definition file - You will also receive a key definition file
   • This file will be manually shared with you by Resonate Client Success.
   • It is a spreadsheet that lists a human readable translation of the survey value keys found in output table
3. Summary file - You will also receive a summary file:
   • This file will be manually shared with you by Resonate Customer Success.
   • Use this file to verify that your Output and Key definition files are correctly aligned.

Read more here to understand your output file.

The Data Share is now complete!