Featured Posts
Two Ways to Enrich Directly in the Warehouse
Copy our SQL to enrich data directly in your warehouse, or try it via our HTTP enrichment protocol.
Understanding Gemini: Costs and Performance vs GPT and Claude
See how Gemini's flash and pro models measure up against GPT and Claude, and understand which ones to use for which tasks.
GPT vs Claude: What's The Best AI Model?
Which models are the most performant and cost effective? Which win at what use cases?
Marketing teams: You don't need a CDP. The future is the data warehouse. | Census
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.
Analytics engineer or data engineer: Who's right for the job? | Census
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.
OA Book Club Catch Up Vol. 1 : Decisions, decisions, decisions from the Fundamentals of Data Engineering | Census
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.
Build or Buy? 4 Reasons NOT to Build Your Own Reverse ETL | Census
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.
Why marketers should care about the data warehouse | Census
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.
Why you need reverse ETL right now | Census
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).
How to solve the unexpected ‘eof’ syntax error in Snowflake | Census
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.
Lessons from the trenches: Advice for women early in their analytics career | Census
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.
🦃 What’s New in November: Sync Sequences, Prefect partnership, static list sync improvements | Census Sync
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.
How to Fix SQL Compilation Error: Missing Column Specification | Census
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.