Census changelog
Census changelog

dbt Models Integration: now supporting GitLab repositories




The Census dbt Models integration now supports repositories hosted in GitLab, in addition to GitHub. Use the dbt Models integration to sync your dbt models directly to destinations, view your dbt model definitions, and build Census Entities and Segments off of dbt models.

When setting up the dbt Models integration on the Models > dbt Project page, you'll now have the option to select your git hosting provider.

Screen Shot 2023-03-09 at 12.16.20 PM.png

Git-backed Models: Use Git to govern your Reverse ETL workflows




Git-backed Models is a bi-directional Git integration that enables data teams to manage Census SQL models with software development best practices.

Bring all the benefits of Git to your Reverse ETL workflows. πŸš€

Git-backed Models YAML.png

In summary, Git-backed Models offer:

  • Resources as Code: Specify your Census SQL models in YAML configuration files.

  • Bi-directional updates: UI or Code – it’s up to you! You and your team members will still have the freedom to make changes in the Census UI (according to your level of access control), or make changes by updating the YAML configuration files in your Git repository.

  • Git-Backed Change History: You can already view and rollback changes to Census SQL models directly within the Census UI. Now – view them as they relate directly to Git commits, either initiated in code or directly in the Census UI.

We’re accepting customers to our beta program now!

πŸ‘‰ Fill out this form and we’ll be in touch to enable Git-backed Models for you.

New Datadog integration – Alerting where it matters




With Census's Datadog integration, you can centralize your monitoring within Datadog and create customized alerts for all your reverse ETL syncs.

Datadog dashboard for Census syncs.png

How to get started:

Census will emit metrics and events that help you understand the health of your data pipelines, alert on anomalies, and manage incidents.

πŸ‘‰ For more details, see the product docs or read the full announcement.

πŸ” Introducing Quick Search: Faster navigation & action in Census




Quick Search is a new feature that enables you to easily search across your entities, segments, datasets, and syncs from anywhere in the app.

Quick Search hero gif with subtitles.gif

Just hit cmd⌘+K (Mac) or ctrl+K (Windows) or click on the search box. The Quick Search bar will automatically suggest relevant results as you type, and you can then select any result to be taken directly there.

Also, you can navigate faster with shortcuts in Quick Search. For example, type new sync and hit enter to be taken directly to the sync creation page, or segment to create a new Segment πŸ™Œ

Now available for all users! Read the full announcement

πŸŽ‰ 18 New Connectors! MySQL, LaunchDarkly, RollWorks, Constant Contact, Pinpoint, PartnerStack, Discord, and more




Changelog_ New connectors Feb 2023.png

February is the month of love, and we're showing you our love by releasing 18 new integrations ❀️ Here they are by category:






  • Discord (messaging and communication)

πŸ‘‰ See all of our destination connectors

Improvements to Orbit and Salesforce



  • Orbit: Activities (Keep tabs on what your community members are up to by syncing data from your warehouse into Orbit.)
  • Salesforce: Email message relations (Associate emails with other objects in Salesforce, e.g. contacts, leads, and accounts.)

dbt Version Detection + 1.4.1 Support




The Census dbt integration now supports version 1.4.1 as its default, but if you require an earlier version in your dbt project, Census will use that version instead. We've upgraded the Census dbt integration so that it always utilizes a version compatible with your dbt project.

Census will now detect a compatible dbt version via the require-dbt-version parameter in your dbt_project.yml file, and use this version when compiling models and running CI Checks. If no version is detected, Census will use its latest supported version (1.4.1 right now).

See the version used in your integration by navigating to Models > dbt Project in your workspace. For more details, please visit our docs.

Screen Shot 2023-02-23 at 2.33.32 PM.png

Census Enrichment: Third-party data enrichment with Clearbit and Apollo.io, now in your warehouse




Census Enrichment youtube thumbnail.png

Census Enrichment makes it possible to connect third-party data sources to the first-party data you already have in your warehouse.

We've partnered with B2B intelligence providers Clearbit and Apollo.io to add enrichment to Census Entities with just a few clicks.

Now, you can easily:

  • Build the most complete Customer 360 and activate it in any tool
  • Segment customers and send personalized messaging with better data
  • Simplify enrichment workflows, integrate fragmented data, and reduce costs

πŸ‘‰ Learn more: Read the full announcement or watch a step-by-step demo.

πŸ‘‰ For detailed information, read the product docs.

πŸŽ‰ New Connectors: Qualtrics, Vero, and OneSignal




Changelog_ New connectors Jan 2023.png

  • Qualtrics - Surveys and user feedback
  • Vero - Multi-channel marketing
  • OneSignal - Push notifications and messaging

πŸ‘‰ See all of our destination connectors

Improvements to Vitally, Facebook Ads, Jira, HubSpot, Salesforce Marketing Cloud, Userflow, Courier