The Pattern
Data warehouse (Snowflake, BigQuery, Databricks) holds enriched analytics. Reverse ETL syncs it into CRM for activation — lead scores, account health, product signals. Warehouse as source of truth; CRM as operational surface.
Vendor Options
Census and Hightouch dominate standalone reverse ETL. Salesforce Data 360 zero-copy federation provides a native alternative. HubSpot Operations Hub data sync covers common cases. Pick based on complexity and existing stack.
Data 360 Alternative
Zero-copy federation queries warehouse data directly from Salesforce — no sync required. Reduces duplication, latency, governance burden. Fits well for read-heavy activation; syncing still useful for high-frequency writes.
Implementation Reality
Reverse ETL looks simple; in production, data quality, schema drift, sync reliability, and monitoring are ongoing work. Budget for the platform plus ongoing engineering attention.