Zero-Copy Integrations Between Your CDP and Data Warehouse

Not exactly. Zero copy is an industry term that is a bit misleading. Zero copy or zero ETL is the ability to access data in a data warehouse or other system without having to move, copy, or transform it. However, the CDP will store query results and, in some instances, create temporary tables, all of which expire after seven days. The benefits are the same as less data is transferred and stored, resulting in lower costs and improved performance.

A federated query is the ability to query and analyze data across multiple operational databases, data warehouses, and data lakes without moving the data into the CDP. 

The Treasure Data CDP includes a federated query capability with Live Connect that can leverage your data warehouse’s native query interface.

The answer is – it depends. Both a data warehouse and a CDP can be a single source of truth for customer data, but for different reasons. 

Typically, a data warehouse is used for storing raw data, both structured and semi-structured, from across the enterprise, making it the best source of truth for the entire organization’s data. The data warehouse supports large data storage and processing, as well as complex querying.

A CDP is purpose-built for customer data. It also supports real-time personalization, omnichannel orchestration, and provides a UI accessible to marketing teams, making it ideal as a single source of truth for customer experience and marketing use cases.

Global 2000 enterprises from around the world are finding that CDPs and DWHs work best in tandem.

Most enterprises require multiple ways to integrate their CDP with their data warehouse. Treasure Data CDP provides three ways to do this, which can be used individually or in combination:

• Zero Copy: With zero-copy data transfer, the CDP can access your data in the data warehouse without copying it over to the CDP.
• Batch copy: Batch copy enables you to move large quantities of data between your CDP and data warehouse.
• Easy Sync: Use Easy Sync to transfer multiple tables of data between your CDP and data warehouse at the same time.

How do you know which approach is right for you?

• Small to medium-sized companies that have minimal complexity and straightforward use cases typically use Zero Copy.
• Enterprise companies with real-time needs, complex technology ecosystems, and mature customer experience and marketing use cases usually require a combination of approaches.

Your data warehouse is excellent for storing data across the enterprise, including customer data, due to its ability to handle large-scale data storage and support complex analytical queries.

But if you are looking for a solution that enables your marketing team to easily utilize customer data that resides in multiple systems for campaigns and analysis, transferring relevant data to the CDP is a more appropriate approach.

The CDP provides specialized customer data capabilities that a data warehouse lacks, such as real-time customer engagement, advanced audience segmentation, and cross-channel activation. The CDP also includes built-in data privacy and compliance tools.