Skip to main content
Skip table of contents

Redpoint + Snowflake + Databricks

Architecture summary

In this reference solution architecture document, we present a strategic framework for integrating Redpoint Global's Customer Data Platform (CDP) with Snowflake's cloud-based data warehousing and analytics platform along with Databricks' cloud-based data engineering and analytics platform. This integration is designed to create a powerful data architecture that enables efficient data management, advanced analytics, and personalized customer experiences.

By outlining the technical and strategic considerations, this document serves as a comprehensive guide for our internal users, partners, and clients, empowering them to effectively unify customer data, derive actionable insights, and make data-driven decisions with unparalleled speed and accuracy. The architecture aims to optimize data utilization across platforms, enhance data governance and security, and provide a unified view of customer data.

With Snowflake's scalable and high-performance data warehousing capabilities, organizations can efficiently store, manage, and analyze massive volumes of customer data, enabling real-time insights and personalized customer experiences. By integrating Redpoint CDP with Snowflake, businesses can unlock the full potential of their customer data, drive innovation, and gain a competitive edge in today's data-driven landscape. Additionally, by working in tandem with Databricks, organizations can gain valuable insights through advanced analytics and machine learning.

Example use cases

  • Unified customer view for personalized campaigns and experiences across multiple channels

  • Advanced customer segmentation for targeted outreach

  • Real-time customer insights for immediate action

  • Predictive analytics to forecast customer behavior

  • Simplified data governance and compliance management

  • Enhanced data security and privacy controls

  • Scalable data storage for growing customer data volumes

  • Enhanced machine learning models to generate valuable insights for customer preferences and recommended products and content

Logical diagram

snow-databricks.png

Key components and roles

  • Redpoint CDP

    • Unified profile of individuals

    • Identity resolution with key persistence

    • API-accessible single customer views

    • Audience definition / segmentation

  • Snowflake

    • Data warehouse and storage

    • Secure data sharing

    • Data governance

    • Data modeling

    • Scalable point of data integration

  • Databricks

    • Apache Spark-based

    • Collaborative notebooks

    • Scalable data processing

    • Unified analytics platform

    • ML lifecycle management

    • Cloud-native architecture

Data flows

Source system

Target system

Representative data

Transfer mechanism

Cadence

Notes

Redpoint

Snowflake

Demographic
Offer History
Modeling data
Aggregates

ODBC/JDBC

Redpoint sits directly on Snowflake and is able to query the databases and secure data shares without any data movement.

Website

Redpoint

Web Events

Realtime Services

Milliseconds

Redpoint

Website

Real-time decisions
Visitor Profile

API

Milliseconds

Transactional Systems

Redpoint

Transactions/Behaviors

API/Batch/Queue

Seconds

Snowpark

Redpoint

Model Scores
Next Best…

ODBC/JDBC

Seconds

Redpoint

Snowpark

Offer History
Core Identity
Behaviors
Demographics

ODBC/JDBC

Seconds

Redpoint

Databricks

Offer History
Core Identity
Behaviors
Demographics
Transactions

ODBC/JDBC

Seconds

Databricks

Redpoint

Predictive Models
Product Recommendations
Customer Insights
Campaign Optimization
Customer Journey Insights

ODBC/JDBC

Seconds

Databricks

Snowflake

Aggregated Data
ML Outputs
Feature-Engineered Data
Time-Series Data
Graph Data
Segmentation Data

Native Databricks Connector

Seconds

Additional information available here: https://docs.snowflake.com/en/user-guide/spark-connector-databricks

Data Science

Redpoint

Model Scores

Next Best…

API/Batch

 

 

Redpoint

Data Science

Offer History
Core Identity
Behaviors
Demographics

API/Batch

 

 

Why does this architecture/solution make sense?

In this architecture, Redpoint CDP acts as the central hub for customer data collection, unification, and enrichment, serving as the single source of truth for customer data, both consuming data from and persisting data within Snowflake. Snowflake functions as the robust and scalable data storage and processing powerhouse, enabling efficient data warehousing, advanced analytics, and secure data sharing. By integrating these two platforms, organizations can create a seamless data pipeline that leverages the strengths of each system.

Redpoint CDP's ability to collect and refine customer data from various sources, coupled with its advanced identity resolution and data quality management capabilities, ensures that high-quality, unified customer profiles are readily available. Snowflake's cloud-based architecture and near-infinite scalability allow for the storage and processing of massive volumes of customer data, enabling real-time analytics and insights. Databricks provides an enterprise solution for processing, analyzing, and deriving insights from large volumes of structured, semi-structured, and unstructured data.

This integration empowers organizations to break down data silos, achieve a holistic view of their customers, and make data-driven decisions with unparalleled speed and accuracy. By leveraging Snowflake's data sharing capabilities, organizations can securely share customer insights across departments and with external partners, fostering collaboration and innovation. Moreover, the combined solution helps organizations maintain data governance and compliance with global data privacy regulations, as both platforms prioritize data security and privacy.

The Redpoint CDP + Snowflake architecture creates a powerful, end-to-end customer data management and analytics solution that drives personalized customer experiences, optimizes marketing strategies, and fuels business growth in today's data-driven landscape.

The addition of Databricks brings best-in-class machine learning capabilities that can process large amounts of customer data to generate meaningful insights.

By using these three platforms together, the solution can help the client form a robust data ecosystem that empowers their organization to efficiently manage data, perform advanced analytics, and deliver personalized experiences to their customers.

Business benefits

  1. 360-Degree Customer View: By integrating Redpoint CDP, Snowflake, and Databricks, organizations can achieve a comprehensive, unified view of their customers, enabling them to deliver highly personalized experiences, improve customer satisfaction, and increase customer lifetime value.

  2. Enhanced Data-Driven Decision Making: The combination of Redpoint CDP's data unification and enrichment capabilities with Snowflake's advanced analytics and real-time data processing along with Databricks' advanced machine learning capabilities, empowers businesses to make informed, data-driven decisions that drive growth, optimize marketing strategies, and improve operational efficiency and return on ad spend (ROAS).

  3. Scalability and Performance: Snowflake's cloud-based architecture and near-infinite scalability, coupled with Redpoint CDP's robust data management capabilities, allow organizations to efficiently store, process, and analyze massive volumes of customer data, ensuring optimal performance and the ability to grow with the business. Integrating Databricks for advanced machine learning will further create meaningful insights on customer data that will drive a highly personalized and relevant customer journey.

  4. Secure Data Sharing and Collaboration: Snowflake's secure data sharing features, combined with Redpoint CDP's data governance and compliance capabilities, enable organizations to safely share customer insights across departments and with other providers (such as Databricks), fostering collaboration, innovation, and data-driven decision-making.

  5. Reduced Data Silos and Improved Efficiency: By integrating Redpoint CDP, Snowflake, and Databricks, businesses can break down data silos, streamline data management processes, and reduce the time and effort required to derive valuable customer insights, ultimately improving operational efficiency and reducing costs.

Technical benefits

  1. Unified and Enriched Customer Data: Redpoint CDP's advanced data unification and enrichment capabilities consolidate customer data from various sources, creating a single, comprehensive view of each customer and enhancing data quality for accurate analysis and targeting.

  2. Scalable and High-Performance Data Warehousing: Snowflake's cloud-based architecture and near-infinite scalability enable organizations to store, manage, and process massive volumes of customer data efficiently, ensuring optimal performance and the ability to handle growing data needs.

  3. Real-Time Data Processing and Analytics: Snowflake's real-time data processing capabilities, combined with Redpoint CDP's data streaming features, allow organizations to analyze customer data and derive actionable insights in real-time, enabling faster decision-making and more responsive customer engagement.

  4. Seamless Data Integration and Connectivity: The integration between Redpoint CDP, Snowflake, and Databricks is streamlined, leveraging Snowflake and Databricks' respective ODBC and JDBC drivers for efficient querying and data transfer. Likewise, native integration between Databricks and Snowflake can also be utilized.

  5. Robust Data Security and Compliance: Redpoint CDP, Snowflake, and Databricks all prioritize data security and privacy, offering advanced security features such as encryption, access controls, and data governance tools to protect sensitive customer data and ensure compliance with global data privacy regulations.

  6. Collaborative Data Sharing and Accessibility: Snowflake's secure data sharing capabilities allow organizations to easily share customer data and insights across departments and with other providers such as Databricks.

  7. Simplified Data Governance and Lineage: The combined solution simplifies data governance by providing tools for data lineage tracking, data cataloging, and metadata management. This ensures that data is consistently and accurately defined, making it easier to maintain data quality, comply with regulations, and track data usage across the organization.

Overall architectural considerations

  • Redpoint CDP, Snowflake, and Databricks are powerful platforms that offer complementary capabilities for managing and deriving insights from customer data. While there is some overlap in their functionalities, each platform brings unique strengths to the table. By integrating these platforms strategically, organizations can create a synergistic architecture that leverages the best of each tool while maximizing the benefits of their overlapping capabilities.

  • Snowflake and Databricks both charge based on the amount of data stored and the compute resources consumed.

  • To maximize data transfer performance between Databricks and Snowflake, both platforms should reside in the same cloud and region, and utilize the native connectors between the platforms.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.