Featured Posts

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
CSV Datasets and fighting rogue data
CSV Datasets and fighting rogue data
Census CSV Datasets give scattered business data a home. Upload, transform, and activate spreadsheet information without coding or engineering resources.
Arjit Jaiswal
3 April 2025
Introducing Census SaaS Datasets: Connect, Transform, and Activate Your SaaS Data
Introducing Census SaaS Datasets: Connect, Transform, and Activate Your SaaS Data
Get quality data faster by connecting any SaaS app to your modeling and enrichment tools
Ellen Perfect
12 March 2025
Best Practices
Marketing teams: You don't need a CDP. The future is the data warehouse. | Census
Sylvain Giuliani
9 December 2022
Five years ago, CDPs seemed like the best solution for marketing teams to collect customer data. Now, data-forward companies are shifting toward an alternative: Activating their data warehouse.
Best Practices
Analytics engineer or data engineer: Who's right for the job? | Census
Madison Schott
8 December 2022
Analytics engineer, data engineer... What's the difference? More importantly, who's best equipped to solve your pain points? Here's your helpful guide to hiring for each of these roles.
Events
OA Book Club Catch Up Vol. 1 : Decisions, decisions, decisions from the Fundamentals of Data Engineering | Census
Zachary Pollatsek
8 December 2022
If you missed the first OA Book Club meeting, don't stress! We've got you covered with this in-depth recap of the first three chapters of the Fundamentals of Data Engineering. Check it out here.
Best Practices
Build or Buy? 4 Reasons NOT to Build Your Own Reverse ETL | Census
Allie Beazell
7 December 2022
It's not the initial development cost, but rather the ongoing time and resources maintaining the tool that will cost you. Let’s take a look at some numbers.
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.