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.
BigQuery icon
Google Sheets icon
Heroku Postgres Connect icon
MySQL icon
Data Build Tool (dbt)
Databricks icon
Looker icon
Azure Synapse icon
Athena icon
Elastic search
AWS S3 Integration
SQL Server icon
Redshift icon
Snowflake icon
Rockset icon
panoply icon
Postgres icon
Census logo
Census logo
SendGrid icon
Stripe icon
Drift icon
SQL Server icon
Heap Analytics Icon
Mailchimp icon
Salesforce logo
ActiveCampaign icon
Great Question icon
Twitter Ads icon
ChurnZero icon
Google Ads Icon
Apollo icon
Google Search Ads 360 icon
Oracle Fusion Cloud
Freshsales icon
Sailthru icon
Help Scout icon
Shopify icon
GCS icon
Planhat icon
Vitally icon
Userflow icon
pinterest icon
Microsoft Teams icon
Orbit icon
LinkedIn Ads icon
Datastore logo
PostHog icon
Hubspot icon
tiktok icon
Gainsight icon
Courier icon
The Trade Desk icon
Facebook Ads Logo
correlated logo
Close.io icon
ChartMogul Integration Logo
Campaign Monitor icon
Instagram Ads icon
Oracle Netsuite icon
Poplar icon
Front icon
Appcues Integration Logo
Notion icon
Totango icon
Zendesk icon
Anaplan icon
Stripe icon
Braze icon
Facebook Ads icon
Zapier integration logo
Webhooks icon
Microsoft Ads Icon
Custom destination API icon
Ortto icon
Userpilot icon
Klaviyo icon
Jira icon
Segment icon
Google Analytics 4 icon
mParticle icon
Asana icon
Salesforce Marketing Cloud icon
Snapchat icon
Marketo icon
Algolia icon
Kustomer CRM icon
Pendo icon
Zendesk icon
Postgres icon
Amplitude icon
Google Ads icon
Chargebee icon
Customer.io icon
Mixpanel icon
Outreach icon
User Interviews icon
Iterable icon
Airtable icon
Microsoft Ads icon
Google Analytics integration
Zuora icon
Criteo icon
Pipedrive icon
Autopilot icon
Intercom icon
SFTP icon
Calixa icon
Dynamics 365 icon
Slack
FullStory icon
Zoho icon
S3 icon
Pardot 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
Where can Census sync to in dbt?
No items found.
Need help getting started with dbt?
Connect with us and we'll help you get dbt connected to Census in 30 minutes or less! In addition, we can answer any questions you have about the platform or what you can do with it. We've seen a lot of powerful use cases!

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
dbt
features:

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.