Resonate Append File Transfer – Snowflake Setup and Delivery

Resonate offers flexible methods for sharing and delivering data with our clients, including Box, AWS, SFTP, and Snowflake.

This article covers the specifics for Snowflake. There are various ways in which you can send and receive data via Snowflake, and it's important to note that the correct method is via Data Sharing 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

Supported Snowflake regions

Resonate sends and receives Snowflake data in 10 commercial US regions on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP). Share your input table with the Resonate account for your region. Resonate returns your outputs as a share from that same account. You find them under “Shared with you” in the account you shared from.

Account locators are unique only within a region. When you contact Resonate about your share, give your Snowflake region along with your account identifier.

Overview

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

1. Confirm your Resonate Append attribute and/or cluster selection
2. Create a table using the Resonate prescribed format in your Snowflake account
3. Share the table with Resonate
4. Resonate processes the data within the agreed upon SLA
5. You will 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 Resonate Append refresh

Detailed Steps

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

1. Work with your Resonate Customer Success Manager to select the Resonate Append attributes and/or clusters that include attribute values which fulfill your business needs.
2. The Resonate Customer Success 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 contact is aware of your selections.

Step 2: Create a table in your Snowflake account

Create the table in your Snowflake account following the formatting and guidance we've provided within this article—Including a helpful template to get you started. 

Step 3: Send the Data to Resonate

1. Create the Snowflake table data per the data specifications above.

2. Share the data with Resonate

   In Snowflake, navigate to Data sharing › External sharing

   • Select the “Shared by your account” tab

Select the Data Table you want to share and click Done

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

Add the Resonate account locator for your region (see Supported Snowflake regions) in Add accounts and click “Create Share.”

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 within the expected SLA timeline. Please check in with your Resonate Customer Success Manager to let them know that the data has been shared to ensure our process is as efficient and timely as possible.

Step 5: You will receive 3 deliverables from us

We've covered the Resonate Append deliverables you will be receiving and how to interpret those deliverables.

The Key Definition, Summary and Output Tables will be shared via Snowflake. Your Customer Success Manager will notify you once they have shared the tables with you. Follow these steps to retrieve them:

• In Snowflake, navigate to Data sharing › External sharing
• Select the “Shared with you” tab on the same Snowflake account from which you initially shared your table with our team
• 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: 

Your data share is now complete. Read more here to understand how to interpret and use the three files we have delivered.