Census

Census is a reverse ETL platform that operationalizes data warehouses by syncing modeled tables and SQL/dbt outputs directly into downstream business tools like Salesforce, HubSpot, Marketo, Braze, and ad platforms, without requiring engineers to write and maintain custom API integration scripts. The architecture sits on top of existing cloud warehouses (Snowflake, BigQuery, Redshift, Databricks, PostgreSQL) as the source of truth, using a metadata-driven sync engine that performs incremental change-data-capture, field-level mapping, and multi-threaded batch writes against destination APIs while respecting each SaaS platform's rate limits and schema constraints. Under the hood, Census exposes a model-first workflow: analysts define entities via raw SQL, dbt models, or Looker/dbt Semantic Layer integrations, and Census handles the sync scheduling, dependency graph, and destination-specific object/field mapping through a UI or the Census CLI/Terraform provider for infrastructure-as-code deployments. It supports both batch (scheduled or triggered by dbt Cloud/Airflow jobs) and streaming-style syncs via its Live Syncs feature for near-real-time activation, plus a Census Embed API for building customer-facing data activation into products. Observability is handled through sync-level logging, row-level error diagnostics, and webhook/Slack alerting. The primary users are data engineers and analytics engineers who own the warehouse layer, plus revenue operations and growth teams who consume the synced data in GTM tools, making Census a bridge between the modern data stack (dbt, Fivetran, Airbyte) and operational SaaS systems. It differentiates from traditional ETL/iPaaS tools (Zapier, Workato) by being warehouse-native and SQL-first rather than event- or API-first, and it competes directly with Hightouch and Rudderstack Reverse ETL in the CDP/data-activation category.