Census is a reverse ETL platform - it runs data integration in the opposite direction from most tools. Instead of pulling data into the warehouse, Census pushes modeled data out of the warehouse into the operational tools where teams actually work: Salesforce, HubSpot, Marketo, Zendesk, Slack, and dozens more. This practice, often called data activation or operational analytics, turns the warehouse from a reporting destination into the source of truth that drives day-to-day systems.
Why reverse ETL exists
Modern teams model rich data in the warehouse - customer health scores, product-usage signals, lifecycle stages - but that value is stranded if it only appears in a dashboard. A salesperson lives in the CRM, not in a BI tool. Census closes that gap: define the data in the warehouse (often as a dbt model), map it to fields in a destination app, and Census keeps the app in sync. The score you computed in SQL shows up next to the account in Salesforce, where it changes what someone does.
How it works
You connect the warehouse, define a sync from a query or table to a destination object and its fields, and choose how often it runs. Census handles the hard parts of syncing to operational APIs: diffing to send only what changed, respecting rate limits, mapping identities, and managing errors. Because it builds on the warehouse as the source of truth, it pairs naturally with dbt - your transformations define what gets activated.
Where it fits
- Operationalizing warehouse data into CRM, marketing, and support tools.
- Teams practicing data activation with the warehouse and dbt as the source of truth.
- Replacing brittle, hand-built scripts that copy warehouse data into SaaS APIs.
When to look elsewhere
Census is for getting data out of the warehouse. To get data in, you still need a standard ELT tool like Fivetran or Stitch. If you need bi-directional sync or database-to-database movement as well as reverse ETL, a more general tool like Polytomic may cover more ground.
How it compares
Census and Hightouch are the two best-known dedicated reverse-ETL platforms, both centered on warehouse-to-SaaS activation. Against general movement tools like Polytomic, Census is more focused on the activation use case and its catalog of business-app destinations. It complements rather than replaces inbound ELT - the two run in opposite directions around the same warehouse.
Frequently asked questions
What is reverse ETL? Syncing modeled data from the warehouse into operational tools (CRM, marketing, support), so business teams act on it where they work - the opposite of standard ETL.
Does Census replace Fivetran? No - they're complementary. Fivetran loads data into the warehouse; Census activates it out to SaaS tools.
Does Census work with dbt? Yes - syncs commonly source from dbt models, making the warehouse the governed source of truth for activation.