The Operator | Census

The Official Census Blog

Check our product

Subscribe to OA Digest

Top Content

Featured

What is Operational Analytics (and how is it changing how we work with data)?

Rather than empowering teams, they often have to choose between fresh or accurate data; being able to trust it, or taking quick action on it. Operational Analytics solves this pain point to drive action w/ real-time data to all the tools you need.

Sylvain Giuliani

Sylvain Giuliani and

What is "data as a product" really?

If you're on Data Twitter, Data Slack, or subscribe to a data newsletter, chances are you're no stranger to the "What is data as a product?" debate. Here, we've rounded up the most popular views so you can decide for yourself.

Parker Rogers and

What is reverse ETL? Here's everything you need to know.

Feel like you should be able to do so much more with all that data you've been collecting? Now a new class of data tools known as reverse ETL (rETL) can help you move data from a data warehouse into 3rd-party systems to make data operational.

Sylvain Giuliani

Sylvain Giuliani and

Census partners with Google Cloud to make BigQuery data more actionable

Today, Census officially achieves Google Cloud BigQuery partner status! Our mutual customers like Fivetran, Bitly, Mixpanel, and Clearbit use Census to operationalize the data in their warehouse and provide actionable insights in every business tool.

Prefect and Census Partnership Announcement

Census is proud to announce our partnership with Prefect to empower our users to get the most out of their data. Together, Census Reverse ETL and Prefect dataflow automation make data engineering enjoyable and effective.

Announcing Census Notifications: Business metric alerting with your data warehouse

Announcing Census ⚡️ Notifications: Set up business metric alerting using your single source of truth. Use the new visual builder to trigger automatic Slack or Teams messages to GTM teams that send when customer data in your warehouse changes.

Announcing Workspaces: Organize your syncs by team or project

Releasing Workspaces, the next level of governance for your Census account. Workspaces enable you to manage permissions granularly for different teams, projects, or use cases. You can organize syncs and models in Workspaces however you wish.

🎃 What’s New in October: Google BigQuery partnership, Notifications, Workspaces, Google Analytics 4 integration

Rounding up exciting announcements from October! Official Google Cloud BigQuery partnership, new product releases for Notifications and Workspaces, integrations with Google Analytics 4 and SQL Server.

🦃 What’s New in November: Sync Sequences, Prefect partnership, static list sync improvements

Rounding up exciting announcements from November! New Sync Sequences product release, official partnership with Prefect, and static list sync improvements for marketing connectors. Also, our blog on why marketers should care about the data warehouse.

Latest

Search our full library

How to solve the unexpected <EOF> syntax error in Snowflake

Error messages during coding are supposed to help you debug, but sometimes, these messages are more ambiguous than helpful — like the unexpected <EOF> error. Here's what it means and how to fix it.

Sooter Saalu and

How to solve the unexpected <EOF> syntax error in Snowflake

Error messages during coding are supposed to help you debug, but sometimes, these messages are more ambiguous than helpful — like the unexpected <EOF> error. Here's what it means and how to fix it.

[Part 1] Why reverse ETL (and why reverse ETL now)?

In part one of our series on evaluating reverse ETL tools, we dive into why you should invest in reverse ETL in the first place (and why you should do it right now).

Allie Beazell and

[Part 1] Why reverse ETL (and why reverse ETL now)?

In part one of our series on evaluating reverse ETL tools, we dive into why you should invest in reverse ETL in the first place (and why you should do it right now).

Lessons from the trenches: Advice for women early in their analytics career

Career paths in data are still pretty undefined, especially if you're you're one of the first data hires at your company. Check out this SCD session recap to learn some firsthand tips.

Nicole Mitich and

Lessons from the trenches: Advice for women early in their analytics career

Career paths in data are still pretty undefined, especially if you're you're one of the first data hires at your company. Check out this SCD session recap to learn some firsthand tips.

Best Practices

[Part 1] Why reverse ETL (and why reverse ETL now)?

In part one of our series on evaluating reverse ETL tools, we dive into why you should invest in reverse ETL in the first place (and why you should do it right now).

Allie Beazell and

Lessons from the trenches: Advice for women early in their analytics career

Career paths in data are still pretty undefined, especially if you're you're one of the first data hires at your company. Check out this SCD session recap to learn some firsthand tips.

Nicole Mitich and

How understanding the data engineering lifecycle helps us all work better with data engineers

Understanding the data engineering lifecycle helps every role on the team perform better and get the results they're after. Check out this SCD session recap to learn how.

Nicole Mitich and

Sign up for The Operational Analytics Digest to get the best (and freshest) data content from the community delivered to your inbox.

Tutorials

How to solve the unexpected <EOF> syntax error in Snowflake

Error messages during coding are supposed to help you debug, but sometimes, these messages are more ambiguous than helpful — like the unexpected <EOF> error. Here's what it means and how to fix it.

Sooter Saalu and

How to solve the SQL compilation error: "Missing column specification"

If you've been around the Snowflake block a time or two, it's more than likely that you've encountered the dreaded SQL compilation error: "Missing column specification." Here's how to fix it.

Furqan Butt and

Snowflake and SQLAlchemy tutorial: From installation to example queries

SQLAlchemy is one of the most popular libraries to interface with relational databases in Python. So how can you leverage this to interface with Snowflake? Check out this step-by-step tutorial.

Roel Peters and

Join the Operational Analytics Club

Product News

🦃 What’s New in November: Sync Sequences, Prefect partnership, static list sync improvements

Rounding up exciting announcements from November! New Sync Sequences product release, official partnership with Prefect, and static list sync improvements for marketing connectors. Also, our blog on why marketers should care about the data warehouse.

Announcing Sync Sequences

Now announcing Sync Sequences, allowing you to run a sync based on the successful run of another sync. Say hello to dependencies between syncs and goodbye to orphan contacts.

Sylvain Giuliani

Sylvain Giuliani and

Prefect and Census Partnership Announcement

Census is proud to announce our partnership with Prefect to empower our users to get the most out of their data. Together, Census Reverse ETL and Prefect dataflow automation make data engineering enjoyable and effective.

Learn More

Product

Connect

© Sutro Labs Inc. All Rights Reserved.