Announcing mParticle’s Snowflake integration for modern data warehousing
Learn how the new Snowflake integration can help you warehouse your customer data more efficiently and securely at scale with automated data exports, advanced filtering and compliance, and easier querying.
Snowflake is a data warehouse built for the cloud with instant computing elasticity, which allows organizations to scale their data processes as demand increases. Using the new Snowflake integration, mParticle customers can instantly populate their Snowflake data warehouse with clean customer data ingested by the mParticle platform. This integration provides brands with automated data exportation, advanced filtering and compliance features, data replays, and data table views for easier, faster, and more stable customer data warehousing at scale.
Automated data exports
One of Snowflake's most useful capabilities is its efficient handling of JSON data. With mParticle, brands can automatically export data points from customer engagements across their entire stack to their Snowflake data warehouse as JSON files. This automated data export takes out the manual processes and ensures that the customer data in your warehouses are as up to date as possible.
Advanced filtering and compliance
Brands using the mParticle Snowflake integration have granular control over exactly what data is sent to their Snowflake data warehouses with advanced filtering. This advanced filtering ensures that brands send only the most pertinent customer data to their warehouses and can help curb warehousing costs caused by unnecessary data importation.
This granular control over customer data forwarding can also help companies comply with data privacy regulations. mParticle keeps your entire data ecosystem compliant with GDPR data subject rights by managing and fulfilling your data subject deletion requests. Using this integration, companies can rest easy that they are making the most of their customer data while ensuring that they respect customer's privacy.
mParticle tolerates integration downtime by maintaining your data for up to 30 days without an active connection. In the case of extended downtime, we can perform a replay of your data to Snowflake.
To improve ease of querying both directly and from BI platforms, mParticle creates views on top of snowflake tables to expose each JSON field as a column so that BI platforms and users can run regular SQL queries.
Latest from mParticle
Cross-border data flows and Privacy Shield
On July 16, 2020, the Court of Justice of the European Union issued a ruling that declared Privacy Shield invalid. Privacy Shield was a program administered by the US Department of Commerce that enabled mParticle and other Privacy Shield participants to transfer EU personal data into the US. We appreciate that mParticle customers who process EU data may have important questions about the impact of this ruling.
Executive Panel: The Digital Future of Food & Beverage
Amidst the pandemic, the brick-and-mortar Food & Beverage industry has been forced to adapt and modernize quickly — adopting new technologies and refocusing priorities overnight. Learn how pioneers at industry-leading brands are building their digital experiences, and what they think the future will look like.
Data Partners Program: Seamless first- and third-party data enrichment
The newly debuted Data Partners Program is a group of enrichment data partners that meet the highest standard of data integration with mParticle’s CDP; these integrations allow third-party data to be collected and connected to the first-party persistent customer profiles existing within mParticle to provide a complete, real-time view of the customer which can then be used to seamlessly connect insights to a growing ecosystem of 250+ outbound integrations.
Between two firms: Featuring Hull and mParticle, moderated by the CDP Institute
If you've ever wondered about CDPs and the role they play in both B2B and B2C industries, here is your chance to hear it straight from the source! Listen to Michael Katz (CEO and Co-founder of mParticle), Romain Dardour (CEO and Co-founder of Hull), and David Raab (Founder of the CDP Institute) discuss what CDPs are and how B2B and B2C CDPs differ.