Census

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.
Snowflake icon
Azure Synapse icon
Data Build Tool (dbt)
BigQuery icon
Elastic search
panoply icon
SingleStore icon
MySQL icon
Materialize icon
S&P Global icon
MotherDuck icon
SQL Server icon
Athena icon
Greenplum icon
Postgres icon
AWS S3 Integration
Heroku Postgres Connect icon
Google Sheets icon
Redshift icon
Looker icon
Databricks icon
Census logo
Census logo
Oracle Netsuite icon
Aha logo
Anaplan icon
mParticle icon
Drip icon
Facebook Ads icon
AskNicely icon
Rokt logo
Criteo icon
Meilisearch icon
SendGrid icon
Clearbit icon
Amazon Pinpoint icon
Campaign Monitor icon
Constant Contact icon
Zendesk icon
Slack
Pendo icon
Stripe icon
Optimizely logo
Facebook Product Catalog icon
OneSignal icon
Vitally icon
Monday icon
CJ Affiliate logo
ChurnZero icon
GitLab logo
LinkedIn Ads icon
Amazon EventBridge logo
ChartMogul Integration Logo
LaunchDarkly logo
Custom destination API icon
Instagram Ads icon
Mailgun icon
Intercom icon
Radar icon
Planhat icon
Outreach icon
Azure Blob Storage logo
Adobe Marketo Engage icon
MySQL icon
Google Ads Icon
Airship logo
pinterest icon
SAP Emarsys logo
Google Ads icon
FullStory icon
HubSpot icon
Close.io icon
Datastore logo
Autopilot icon
Great Question icon
Salesforce Marketing Cloud icon
Appcues Integration Logo
Oracle Responsys logo
Jira icon
Qualtrics icon
Salesforce logo
MongoDB icon
Apollo icon
Gladly logo
Chargebee icon
Google Analytics 4 icon
Google Analytics integration
Freshsales icon
PostHog icon
Mixpanel icon
Ortto icon
The Trade Desk icon
data models for sync illustration
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.