The Official Census Blog
Check our product
Subscribe to OA Digest
Subscribe to OA Digest
Top Content
Best Practices
Tutorials
Product News
Product
Integrations
Pricing
Get a Demo
Featured
Best Practices
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
Feb 23, 2022
Best Practices
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
Parker Rogers and
Jan 27, 2022
Best Practices
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
Jan 14, 2022
Product News
Census Segments 2.0 – The most powerful visual segmentation to keep all your marketing audiences fresh
Announcing the latest version of Census Segments, the best audience management solution built on the data warehouse. Now, marketers can easily unlock all the rich customer data in the warehouse and keep their audiences fresh, with no code and no SQL.
Katy Yuan
Katy Yuan and
Dec 12, 2022
Product News
Census Enrichment: Third-party data enrichment, now in your warehouse
Announcing Census Enrichment with launch partners Clearbit and Apollo.io – integrate third-party enrichment data with first-party data in your warehouse. Build the best Customer 360, segment on it, and sync it. All from one place.
Katy Yuan
Katy Yuan and
Feb 15, 2023
Best Practices
Data Activation Trends Coming True in 2023
Data Activation is essential for marketing in 2023. 12 thought leaders share their takes on current Data Activation trends and how the data warehouse transforms marketing use cases like Customer 360 profiles, personalization, and automation.
Katy Yuan
Katy Yuan and
Feb 28, 2023
Product News
Introducing the Census Entity API: Real-time personalization in all your apps
Despite supporting 150+ destinations, users ask “Can I pull my data on demand?” Today that answer is yes! The Entity API enables instant access to 360° warehouse data in your website, app, or internal tool without extra engineering.
Sean Lynch
Sean Lynch and
Mar 15, 2023
Product News
Announcing Census Entities: Define business entities once to make your most important data available for everyone
With Entities, data teams can define and expose the most important data in the warehouse as entities, so business teams can sync and segment without code. Now it’s possible to go from data creation to action immediately, without further engineering.
Katy Yuan
Katy Yuan and
Dec 12, 2022
Product News
Alerting where it matters – Our integration with Datadog
Introducing our new Datadog integration to help data teams guarantee the health of their business-critical pipelines. Centralize your monitoring within Datadog and create customized alerts for all your reverse ETL syncs. Stay ahead of data surprises!
Jeff Sloan
Jeff Sloan and
Mar 03, 2023
Product News
Introducing Quick Search: A faster way to navigate your data in Census
We're excited to announce Quick Search for faster navigation and action in Census. Just hit cmd⌘/ctrl + K, or click on the search box, to search across your entities, segments, datasets, and syncs from anywhere in the app.
Katy Yuan
Katy Yuan and
Mar 01, 2023
Latest
Search our full library
Product News
BigQuery pricing changes: What does it mean for you?
Google Cloud has announced new BigQuery editions with flexible pricing options to cater to your team's diverse data needs. Here's what that means for you.
Sylvain Giuliani
Sylvain Giuliani and
Mar 31, 2023
Product News
BigQuery pricing changes: What does it mean for you?
Google Cloud has announced new BigQuery editions with flexible pricing options to cater to your team's diverse data needs. Here's what that means for you.
Sylvain Giuliani
Mar 31, 2023
Best Practices
How Canva activates its data warehouse for better customer insights
User-friendly graphic design app, Canva, has changed the way people design. Check out what Matthew Castino, lifecycle data lead, had to say about why a traditional CDP wasn't going to cut it for them.
Nicole Mitich
Nicole Mitich and
Mar 16, 2023
Best Practices
How Canva activates its data warehouse for better customer insights
User-friendly graphic design app, Canva, has changed the way people design. Check out what Matthew Castino, lifecycle data lead, had to say about why a traditional CDP wasn't going to cut it for them.
Nicole Mitich
Mar 16, 2023
Interviews
Building better community together: Announcing The OA Club Data Champions
Meet the 10 OA Club Data Champions bringing great educational resources to the Community this year.
Allie Beazell
Allie Beazell and
Mar 16, 2023
Interviews
Building better community together: Announcing The OA Club Data Champions
Meet the 10 OA Club Data Champions bringing great educational resources to the Community this year.
Allie Beazell
Mar 16, 2023
Best Practices
View all
Best Practices
How Canva activates its data warehouse for better customer insights
User-friendly graphic design app, Canva, has changed the way people design. Check out what Matthew Castino, lifecycle data lead, had to say about why a traditional CDP wasn't going to cut it for them.
Nicole Mitich
Nicole Mitich and
Mar 16, 2023
Best Practices
CDPs and the broken promise of the customer 360
By 2023, marketers are brought into the why of data activation, but so long as we continue to rely on out-of-the-box CDPs, we won’t (to our data teams’ dismay) have nailed the how.
Satya Gadepalli
Satya Gadepalli and
Mar 08, 2023
Best Practices
CDP use cases: 6 clever ways to maximize the ROI of your customer data
With customer data at your fingertips, you can improve personalization, segmentation, predictive modeling, omnichannel marketing, and more.
Nicole Mitich
Nicole Mitich and
Mar 02, 2023
Sign up for The Operational Analytics Digest to get the best (and freshest) data content from the community delivered to your inbox.
Tutorials
View all
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
Sooter Saalu and
Dec 02, 2022
Tutorials
How to Fix 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
Furqan Butt and
Nov 30, 2022
Tutorials
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
Roel Peters and
Nov 23, 2022
Join the Operational
Analytics Club
Join the Club
Product News
View all
Product News
BigQuery pricing changes: What does it mean for you?
Google Cloud has announced new BigQuery editions with flexible pricing options to cater to your team's diverse data needs. Here's what that means for you.
Sylvain Giuliani
Sylvain Giuliani and
Mar 31, 2023
Product News
Introducing the Census Entity API: Real-time personalization in all your apps
Despite supporting 150+ destinations, users ask “Can I pull my data on demand?” Today that answer is yes! The Entity API enables instant access to 360° warehouse data in your website, app, or internal tool without extra engineering.
Sean Lynch
Sean Lynch and
Mar 15, 2023
Product News
Introducing Git-backed Models: Use Git to govern your Reverse ETL workflows
We believe your data deserves the same care and attention as production-grade software. Excited to announce Git-backed Models, a bi-directional Git integration that brings peer review, version control, and auditability to Reverse ETL workflows.
Jeff Sloan
Jeff Sloan and
Mar 07, 2023