Featured Posts

Census Joins Forces with Fivetran
Census Joins Forces with Fivetran
Census is joining Fivetran to unify ETL, Reverse ETL, and Master Data Management—creating the first end-to-end platform for trusted, activated data.
Boris Jabes
1 May 2025
Census Entity Resolution: Golden records for your data ecosystem
Census Entity Resolution: Golden records for your data ecosystem
Census Entity Resolution eliminates duplicate records across your data ecosystem, creating golden records that power all your business applications.
Arjit Jaiswal
15 April 2025
Embedded Segment Builder: Powerful audience creation for your platform
Embedded Segment Builder: Powerful audience creation for your platform
Census's Embedded Segment Builder lets your customers create powerful audience segments and activate them across 200+ integrations.
Arjit Jaiswal
7 April 2025
Best Practices
Why marketers should care about the data warehouse | Census
Sylvain Giuliani
7 December 2022
The tide is shifting away from CDPs and towards the data warehouse. And if you can’t access it, or don’t know about it, you’re missing out. Here's why.
Best Practices
Why you need reverse ETL right now | Census
Allie Beazell
2 December 2022
Part 1 of our series on evaluating reverse ETL tools: Why you should invest in reverse ETL in the first place (& why you should do it right now).
Tutorials
How to solve the unexpected ‘eof’ syntax error in Snowflake | Census
Sooter Saalu
2 December 2022
Error messages during coding are supposed to help you debug, but sometimes, these messages are more ambiguous than helpful — like the unexpected error. Here's what it means and how to fix it.
Best Practices
Lessons from the trenches: Advice for women early in their analytics career | Census
Nicole Mitich
1 December 2022
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.
Product News
🦃 What’s New in November: Sync Sequences, Prefect partnership, static list sync improvements | Census Sync
Katy Yuan
30 November 2022
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 & an upcoming webinar with Snowplow, AWS, and Prolific.
Tutorials
How to Fix SQL Compilation Error: Missing Column Specification | Census
Furqan Butt
30 November 2022
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.
Best Practices
Streamline Data Processes with the Data Engineering Lifecycle | Census
Nicole Mitich
29 November 2022
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.
Tutorials
Snowflake + SQLAlchemy Tutorial: Installation & Example Queries | Census
Roel Peters
23 November 2022
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.
Best Practices
Tipping points: How individual decisions make big impacts in data careers & data teams | Census
Nicole Mitich
22 November 2022
All of our careers (and the collective careers of our data teams) are the sum of critical decisions made at the right or wrong time. Drizly's data team grew 7x in just 3 years. Here's how.
Best Practices
Diversity in data: Modeling a better future for data teams | Census
Nicole Mitich
17 November 2022
When it comes to data, as with all other industries, diversity is crucial. Check out this SCD keynote recap to hear some steps you can take to make your data team more diverse.