🎉 We raised $60M Series B to power the rise of Operational Analytics Read the blog→

Sync your data warehouse to dbt

Reverse ETL for dbt

dbt (data build tool) is a data modeling and data management tool that enables analytics engineers to transform data in their warehouses by simply writing select statements.
panoply icon
Databricks icon
Data Build Tool (dbt)
Elastic search
Heroku Postgres Connect icon
Athena icon
Google Sheets icon
MySQL icon
Snowflake icon
Redshift icon
Rockset icon
BigQuery icon
Postgres icon
Azure Synapse icon
Looker icon
SQL Server icon
Census logo
Census logo
Mailchimp icon
Drift icon
Pardot icon
correlated logo
Pipedrive icon
Twitter Ads icon
Campaign Monitor icon
Criteo icon
Kustomer CRM icon
Gainsight icon
Calixa icon
Amplitude icon
Zuora icon
Microsoft Ads Icon
mParticle icon
Notion icon
Freshsales icon
Iterable icon
Marketo icon
Help Scout icon
Webhooks icon
Airtable icon
Salesforce Marketing Cloud icon
Customer.io icon
Shopify icon
Outreach icon
Oracle Netsuite icon
Stripe icon
Totango icon
Stripe icon
Facebook Ads icon
User Interviews icon
Snapchat icon
Facebook Ads Logo
Dynamics 365 icon
Autopilot icon
GCS icon
Algolia icon
Zendesk icon
Appcues Integration Logo
Google Ads icon
ChartMogul Integration Logo
Zendesk icon
Pendo icon
Google Ads Icon
Courier icon
S3 icon
Hubspot icon
Zapier integration logo
Slack
ActiveCampaign icon
Intercom icon
Orbit icon
pinterest icon
Sailthru icon
Custom destination API icon
Front icon
Segment icon
Close.io icon
Userflow icon
Google Analytics integration
Microsoft Ads icon
Salesforce logo
LinkedIn Ads icon
Asana icon
Planhat icon
Mixpanel icon
Vitally icon
Anaplan icon
Braze icon
Klaviyo icon
Oracle Fusion Cloud
Chargebee icon
SFTP icon
SendGrid icon
tiktok icon
Heap Analytics Icon
data models for sync illustration
video play button
Census logo
data part for integration uses illustrationimage part for integration uses illustration
Census logo

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.

Census' native dbt integration offers: 

  • Just in time materialization
  • Syncs triggered on dbt run
  • Selective model syncs and schedules
  • Support for your existing setup
  • Support for all major data warehouses
  • And much more

No items found.
Learn how to connect dbt and Census
Learn how to connect dbt and Census

With Census, we can reuse all of the transformation work we did in dbt and send it to our CRM to be reused. I don't need to do any engineering or anything outside of SQL to get all this done.

Buddy Marshburn
Senior Data Scientist @ Loom

A single source of truth in all your tools

Census is the easiest way to share a consistent view of your data across your entire business.  Define your models, metrics, and business logic in your data warehouse and sync them to all your operational tools.

  • Create trust in consistent metrics
  • Automate confidently with clean data
  • Simplify your data integration strategy
  • Improve data security and visibility
Take action with confidence
Get your free shirt with your free Census account. When you wear it, you’ll know that you're in with the likes of data visionaries at Notion, Mode, Canva, and Loom.