Do more with your dbt models than just reporting

You’ve spent weeks building unified data models with dbt, now you can use them for more than powering BI tools. With our native integration, you can connect your models and materialize them directly into your sales & marketing tools.

dbt video background

These savvy data teams use dbt & Census

Loom logo
Clearbit logo
Drizly logo
Notion logo
Illustrative graph representing dbt data stacks.

Materialize your dbt models in your go to market tools

You don’t have to think about managing yet another materialization schedule or writing and maintaining code to get your data to the tools your marketing & sales teams use. Our native integration takes care of that for you.

Census + dbt = Magic ✨

All the dbt you already love, and more

timer icon
Just In Time Materialization

We execute your dbt model at the time of the sync, so your destinations always have the freshest data.

counterclockwise icon
Selective Model Sync

Use tags in your git repo to only sync the dbt models you want available in your destinations.

database icon
Supports Major Warehouses

Census works with your existing stack. We support Snowflake, BigQuery, Redshift & Postgres.

datastack icon
Works With Your dbt Setup

We automatically respect your existing setup, whether your dbt runner is in-house or dbt Cloud.

simple lock icon
Your Data. Stays your Data.

Census doesn't store your data. The queries & syncs run in your warehouse.

dbt icon
... and all of dbt’s features

Tests, versioning, macros, etc they are all here. It is dbt under the hood.

Enabling Data Contracts for Reverse ETL

Iterate faster in dbt without breaking business workflows
Our vision is to create an environment where Operations and Data teams can collaborate on data projects with confidence.
Creating a reverse ETL sync also creates an implicit contract between teams that data will continue to be trustworthy, high quality, and available.

Our first step towards integrating with your data CI/CD process is dbt Continuous Integration (CI) Checks: a feature to help you double-check that your dbt work won’t break your Census syncs.
Read more →

Census is the Reverse ETL platform of choice for companies who value scalability, observability, and performance.

Performance. Support. Quality. Just three of the reasons Census is the #1 rated Reverse ETL platform on G2.
Here's what reviewers on G2 have to say

"A fantastic tool that is only getting better."

Matthew C
Analytics Engineer

"Like that infomercial rotisserie — you just set it and forget it"

Matt N
Head of Growth

"Census just works"

Eric B
Director of Project Management

“An indispensable tool for BizOps and Go-to-market teams”

Michael T
Business Operations

I used to develop reverse ETL systems with Python and Airflow for destinations like Eloqua, Mixpanel, Braze, Intercom, and Salesforce. Every destination requires different data types, formats, rate limits, and API requests. Census saves me from maintaining my custom code, so I can spend more time to optimize the system itself.

Frances Fang
Sr Data Engineer

Census takes what the analytics team does out of static dashboards and into tools that the rest of the company uses, allowing us to actually deliver on the promise of being “data driven”.

Matt Nicosia
Director of Growth

"A fantastic tool that is only getting better."

Matthew C
Analytics Engineer

"Like that infomercial rotisserie — you just set it and forget it"

Matt N
Head of Growth

"Census just works"

Eric B
Director of Project Management

“An indispensable tool for BizOps and Go-to-market teams”

Michael T
Business Operations
We make it easy to switch to Census.
Your Customer Success team will partner with you every step of the way to make sure you and your team are set up for long term success.

From your data warehouse to your favorite apps. Without code or engineers.

Start using Census today by booking a demo with one of our experts.