Skip to main content

Data Lakehouse

Explore practical guides and implementation patterns for this topic.

Posts

Data 360

Salesforce Zero-Copy Federation Explained: When to Federate vs. Ingest Data

💬 In plain words: Zero-Copy means you do NOT move the data. Your rows stay exactly where they are—in Snowflake, Databricks, Amazon Redshift, or Google BigQuery. Salesforce Data Cloud reads them in place. That means no data pipeline to build, no expensive second copy to store, and no synchronization jobs breaking at 3:00 AM. 🎬 Real-Life Example: 500 Million Rows, Copied Twice Imagine a company with 500 million billing history rows sitting in Snowflake. The Old Way: Data engineers build a complex pipeline to ingest all 500 million rows into Salesforce. The company pays to store the massive dataset twice. They then spend months babysitting the pipeline to ensure both copies stay perfectly in sync. Meanwhile, the data warehouse team views Salesforce as a competitor duplicating their hard work. The Zero-Copy Way: You simply point Salesforce Data Cloud at the existing Snowflake table. The data is queried in place and dynamically joined ...
Read article
Salesforce Architecture & DevOps

Data Lake vs Data Warehouse vs Data Lakehouse: Salesforce Data 360 & MDM Architecture

💬 In plain words: Data Lake: Ingests raw data in any native format quickly and affordably (schema on read). Data Warehouse: Cleans, structures, and indexes curated data for business intelligence and SQL reporting. Data Lakehouse: Combines the massive scale of a data lake with the governance, schema structure, and ACID speed of a data warehouse—the core engine of Salesforce Data 360. Master Data Management (MDM): Resolves duplicate identities across independent systems to create a single, authoritative Unified Individual profile. 📌 Real-World Architecture Analogy: Data Warehouse: The corporate finance data mart—curated star schemas, strict tables, and governed dashboards. Data Lake: The scalable cloud storage bucket (e.g., AWS S3)—storing raw JSON payloads, clickstream logs, and high-frequency IoT feeds. Data Lakehouse: The modern Data 360 architecture—storing raw lake files with warehouse-l...
Read article