Blog

Unlock the Potential of Cleansed, Enriched Data with Acquia CDP and Snowflake Data Sharing

Acquia CDP and Snowflake Data Sharing provide fast, direct access to customer data at scale.

Image
Which Data Matters Most for Personalization?

Companies today are collecting more data than ever before to create engaging customer experiences. Yet as the quantity of data grows, many struggle to transform that data into insights and actions that produce meaningful results. Data Sharing allows deeper integration of data from a customer data platform (CDP) such as Acquia CDP into organizational processes. If the barrier to gain access to clean, processed, current data goes down significantly, each member of your team can be empowered to make data-driven decisions on a daily basis.

Acquia CDP has a strategic partnership with Snowflake, the industry-leading data warehouse that powers Acquia CDP’s analytics applications such as Metrics and Interactive Queries. The joint solution provides reporting and full SQL access to processed, record-level data within Acquia CDP with fast query performance via Snowflake. Marketing, IT and data science teams can thus take advantage of vast amounts of omnichannel customer data enhanced with Acquia CDP’s online-offline identity resolution and predictive analytics.

This collaboration takes our Interactive Queries offering a step further by allowing teams to truly unlock the potential of their cleansed, processed data within Acquia CDP via Snowflake Data Sharing. As part of this new offering, data is instantly shared from Acquia CDP’s Snowflake account (data-provider) into your Snowflake account (data-consumer). With secure data sharing, data doesn’t move, eliminating the cost, headache and delays associated with legacy data sharing method fs that deliver only slices of stale data. Instead, data is immediately available for use in your Snowflake account – no transformation, data movement, loading or reconstruction required.

Key Use Cases and Advantages of CDP Data Sharing

Here are a few examples of how data sharing can be used to drive better business value when combined with the powerful foundation of a CDP. 

Image
acquia and snowflake data sharing
  • Use your favorite BI & analytics platform: It’s a crowded space for BI tools and analytics platforms! Some are more advanced than others and your team may already have a favorite one. While Acquia CDP’s Metrics is built on an industry-leading analytics platform, picking Acquia CDP as your CDP does not mean you have to give up your pre-existing tools and processes for analyzing data. With Data Sharing, you get full JDBC/ODBC connectivity to Acquia CDP’s shared database along with a host of other interfaces in Snowflake’s vast ecosystem. Feel free to check them out in Snowflake's documentation (hint: it’s quite extensive and you will likely find an out-of-the-box connector for your favorite platform).

  • Analyze Acquia CDP’s data with external non-CDP data: Data is everywhere! However, a CDP may not have all operational data such as financial forecasts, supply chain and inventory management, etc. for your business. Often times, marrying transactional data from a CDP to operational data leads to insightful results. This is much easier when all slices of data are available in the same data warehouse. With Data Sharing and Snowflake’s unique architecture, you can join across multiple databases (including Acquia CDP’s shared database) in the same query or report.

  • Build on top of Acquia CDP’s data: The possibilities for what you can do with Acquia CDP’s data are endless, but building your own machine learning (ML) models is one application of Acquia CDP’s data. You may already have a stellar data science team – if not, Data Sharing will enable you to build one! The success of any ML project depends on your access to clean data as soon as it’s available. With Acquia CDP constantly enriching your data and Data Sharing making it available instantaneously in your Snowflake account, you don’t need to depend on your IT team to manage a complex ETL process. Your team can thus run experiments and build models more efficiently leveraging Acquia CDP's data. You could even feed the results of your ML models back to Acquia CDP for usage in Actions and 360 Profiles.

---

For more information on how a CDP can help you collect, unify and activate your customer data, check out our e-book