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.
Heroku Postgres Connect icon
Athena icon
panoply icon
Elastic search
Looker icon
MySQL icon
BigQuery icon
Databricks icon
Snowflake icon
SQL Server icon
Google Sheets icon
Rockset icon
Redshift icon
Postgres icon
Azure Synapse icon
Data Build Tool (dbt)
AWS S3 Integration
Census logo
Census logo
MySQL icon
ActiveCampaign icon
Insightly icon
Klaviyo icon
Campaign Monitor icon
mParticle icon
Amplitude icon
ChurnZero icon
Microsoft Ads Icon
OneSignal icon
Facebook Ads Logo
Marketo icon
Google Analytics integration
User Interviews icon
tiktok icon
Customer.io icon
Sprig icon
Braze icon
Pipedrive icon
Mailchimp icon
Meilisearch icon
Jira icon
Zoho icon
Apollo icon
Pardot icon
Criteo icon
Oracle Fusion Cloud
pinterest icon
Iterable icon
Segment icon
CleverTap icon
Userpilot icon
Kustomer CRM icon
Slack
Drift icon
Gainsight icon
Microsoft Teams icon
Poplar icon
Sailthru icon
Oracle Netsuite icon
Shopify icon
Qualtrics icon
Salesforce Marketing Cloud icon
Hubspot icon
GCS icon
Pendo icon
Notion icon
FullStory icon
Stripe icon
SendGrid icon
Adobe Target icon
Asana icon
Close.io icon
Azure Blob Storage logo
Vero icon
Webhooks icon
Custom destination API icon
Radar icon
Algolia icon
Zendesk icon
SFTP icon
Heap Analytics Icon
Twitter Ads icon
Clearbit icon
Amazon Pinpoint icon
Courier icon
Google Ads Icon
Zuora icon
RollWorks icon
Planhat icon
Airtable icon
Autopilot icon
LaunchDarkly logo
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
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

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

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