On-Demand Snowflake Clean Room File Formatting Guidelines

Please adhere to our file formatting guidelines when sending your data in the clean room to ensure efficient processing and highest possible match rates for your files.

How can you send the data?

Upload your data directly into the Snowflake Native App once you've been granted access. Resonate never has access to that data.

Best Practices for Optimal Match Rates

Reference File Format Example

Reference the file format example below, which shows the required columns and formatting requirements in the correct order. Following this format ensures your file aligns with the clean room's ingestion standards and avoids processing delays. If you do not have a certain ID type (e.g., MAID), leave that column out.

Run the Hashing Script

Resonate developed a hashing script that standardizes email formatting prior to hashing:

• Converts all emails to lowercase
• Removes leading and trailing spaces
• Ensures clean, hash-ready input

Review Email Hashing and Data Cleanliness

To maximize match after running the hashing script, review your file to verify:

• All emails are lowercase
• No leading or trailing spaces

After hashing, ensure hashes are valid alphanumeric outputs. You can validate the details using the file format example within the "Details on each column" tab. For reference, three common hash types and their specifications:

This table does not cover every ID type. See the file format example in the "Details on each column" tab for full specifications by ID type.

It is also worth reviewing your file for general data cleanliness:

• Remove duplicate, inactive, or low-quality records
• Suppress any rows missing critical IDs (e.g., customer ID + HEM, HEM_TYPE, or MAID)
• Remove any rows containing missing key fields or lacking consent (e.g., improperly hashed emails)

See Best Practices for Data Preparation for detailed advice on data cleanliness.

Required Identifiers for Matching

Resonate uses a waterfall matching method, starting with the most precise identifier and cascading to others when necessary. This strategy delivers the highest match possible, even when some IDs are unavailable.

You must include Customer ID and at least one of the following identifiers. Zip11 and name/address are not currently supported for clean room.

Please note: For 60-80% match rate targets, a complete postal address is strongly recommended.

Match Rate Scenarios

Resonate delivers market-competitive match rates, which vary based on the combination and type of identifiers you provide. See Fill Rates, Match Rates, and Waterfall Matching for guidance on reaching and optimizing match rates.

Need Help?

If you are unsure how to format your file or have any questions, contact your Customer Success Manager or email resonatesupport@resonate.com before submitting. We are happy to help ensure your data drives the best possible outcome.