Product News

Model Activity improvements: View & revert changes to SQL models in Census

Katy Yuan
Katy Yuan October 25, 2022

Katy is a Product Marketing Manager at Census who loves diving into startups, SaaS technology, and modern data platforms. When she's not working, you can find her playing pickleball or Ultimate Frisbee.

Maybe your Census models aren’t as crucial as Jack’s decisions in Lost (or maybe they are?)

Either way, Census customers will be happy to know that we’ve made significant improvements to the Model Activity tab. You can now see a detailed log of specific changes to each model, as well as who made those changes. We’re giving you increased transparency into the models that power your critical business workflows, encouraging more visibility and collaboration.

Now, for Census SQL Models you’re able to see a log of changes (approval, rename, etc.) in the Activity tab, in addition to which user made each change. Admin and editor roles can restore a SQL model to a previous query state!

Example of a user who changed the name, description, and query of a model

For models created through a dbt or Looker integration, because they’re not directly managed by Census, you won’t be able to see query changes. However, you can see when a model is approved or unapproved, and when the name or description changes.

Even better, these model history logs are available not only for future changes, but also for past changes! We’ve found activity history for models that are over 3 years old 🤯

Any questions or feedback? Reach out to support@getcensus.com - we love hearing from you!

Related articles

Tutorials
Transforming data Before Syncing with Census Datasets
Transforming data Before Syncing with Census Datasets

The Problem: Your good data is always one request away. Your data team built some great data models in your warehouse; it could be with dbt, or could be plain ol’ SQL — the typical Accounts, Contacts, and Teams golden models. Now you work with another vendor. Maybe a third-party enrichment provider writes open job listings and description data for your warehouse, like Sumble.com. Or perhaps you have an enriched target accounts list generated in another marketing tool.

Product News
Census Datasets: The first step toward collaborative data transformation
Census Datasets: The first step toward collaborative data transformation

Late nights, long hours, and a constant string of tickets and feedback are the reality for most data and IT teams today. As every company’s appetite for data grows, technical teams are forced to scale up support to ensure that the right data lands in the right place. But it doesn’t stop there. Data teams are expected to provide actionable insights, comprehensive data governance, and compliant datasets for their entire organization while juggling new technologies, unclear expectations, and an ever-growing volume of data. Data teams are overwhelmed, business teams are confused and anxious, and everyone is spending more time discussing processes and procedures — and less time innovating.

Product News
Introducing Embedded Reverse ETL Syncs, the future of SaaS integrations
Introducing Embedded Reverse ETL Syncs, the future of SaaS integrations

Looking for a demo? Click here to jump to it on this page.