There are various ways in which you can send/receive data via Snowflake. These steps cover the most preferred method by Resonate, which is to send us your data via Snowflake via Data Sharing. 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 Region = US East (N. Virginia)
- If thats not the case, please follow Snowflake’s guidance to create a new database in Region = US East (N. Virginia) and then follow the process below.
Overview
Overall, there are 5 steps you’ll follow to share and receive Resonate Append data via Snowflake:
- Confirm your Resonate Data Append Cluster selection
- Create a table using the Resonate prescribed format in your Snowflake account
- Send the data to Resonate
- Resonate processes the file and creates output within SLA timeframe
- You receive the deliverables from Resonate.
- Output file on Snowflake
- Definition file from Resonate customer success
*Repeat steps 1-5 for each Data Append refresh
Detailed Steps
Step 1: Confirm Your Resonate Append Cluster Selection
- Work with your Resonate CSM to select the Resonate Data Append clusters that include attribute values which fulfill your business needs.
- The Resonate CSM team will happily guide you through the Cluster selection process.
- Finalize your clusters and make sure your Resonate contact is aware of your selections.
Step 2: Create a table your Snowflake account
Column # |
Column Name |
Field Type |
Field Description / Valid Values |
Sample Field Content |
A |
Customer ID |
String(100) |
Customer supplied unique identifier |
12345 |
B |
Address Line1 |
String(100) |
Upper Case |
123 WASHINGTON STREET |
C |
Address Line 2 |
String(100) |
Upper Case |
APT 10 |
D |
City |
String(50) |
Upper Case |
NORTH ATTLEBORO |
E |
State |
String(2) |
Upper Case |
MA |
F |
ZIP Code |
Numeric(5) |
Five Byte ZIP Code |
27650 |
G |
ZIP+4 code |
Numeric (4) |
four extra digits of ZIP code |
6613 |
H |
Delivery Point code |
Numeric ( 2) |
The two additional digits for delivery point code. Also called as Premise code. Do not include the check digit |
22 |
I |
Household ID |
Numeric(11) |
Complete ZIP11 |
12345123456 |
J |
MAID |
String(64) |
Mobile Advertising ID
|
45lm7n6n-54o3-210p-11q2-12r223242stu |
K |
HEM |
String(100) |
Support values:
MD5 (preferred): 32-character hexadecimal number. For example, ec55d3e698d289f2afd663725127 |
ec55d3e698d289f2afd663725127 |
L |
HEMType |
String(9) |
Support values:
|
HEMSHA256 |
Step 3: Send the Data to Resonate
- Share the table with Resonate once the data is loaded into the Snowflake table.
- There are a few different ways in which you could share the data. Our preferred method is as follows
- In Snowflake, navigate to the “Private Sharing” option in the left navigation menu
-
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 Region - US East (N. Virginia)
-
At this point you have successfully shared the data with us!
Step 4: Resonate will process the data and create an output table for you in the expected SLA timeline.
- Please contact your Resonate Customer Success Manager and let them know that the data has been shared.
Step 5: You will receive 2 deliverables from us
- Output Table - your Resonate Customer Success Manager will notify you once the output file is shared with you
- In Snowflake, navigate to ‘Private Sharing’ on the Snowflake account you initially shared the file from
- You will notice a new file shared by Resonate
- Get the table. The file should look like
- Definition file - You will also a definition file
- This file will be manually shared with you by Resonate Customer Success.
- It is a spreadsheet that lists a human readable translation of the AV keys found on output table
-
Read more here to understand your output file.
-
The Data Share is now complete!
Comments
0 comments
Please sign in to leave a comment.