Register for our upcoming free Webinar "How to use dbt for more than reporting". Register Now for Free 👉

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 preview

These savvy data teams use dbt & Census

Dbt integration with salesforce 
diagram

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

Sync Data

Just In Time Materialization

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

SQL Editor

Selective Model Sync

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

SQL Editor

Supports Major Warehouses

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

SQL Editor

Works With Your dbt Setup

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

SQL Editor

Your Data. Stays your Data.

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

SQL Editor

... and all of dbt's features

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

FAQ

What if I use dbt cloud?


What happened when I update a model?


How do you handle branches in my repo?


How does Census materialize my dbt models?


Can Census read my dbt data?


what version of dbt do you support?