Featured Posts
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.
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.
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.
🦃 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.
Streamline Data Processes with the Data Engineering Lifecycle | Census
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.
Snowflake + SQLAlchemy Tutorial: Installation & Example Queries | Census
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.
Tipping points: How individual decisions make big impacts in data careers & data teams | Census
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.
Diversity in data: Modeling a better future for data teams | Census
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.
Stars, tables, and activities: How do we model the real world? | Census
For 25 years, Ralph Kimball and Margy Ross’s The Data Warehouse Toolkit has provided the mainstream method of data modeling. But is it still relevant? Or is there another alternative?
Operational analytics in B2B startups | Census
Operational analytics empowers organizations, but there are trade-offs between the amount of data you have & its value. Check out this SCD session recap featuring SpatialChat's journey to OA.
Server-side tag manager or reverse ETL: Which one should you use? | Census
How are server-side tag managers and reverse ETL different? How are they similar? Can you use both in your data stack? Here are the answers to these questions and more.
Fix SQL Error 'is not a valid GROUP BY expression' in Snowflake | Census
The SQL compilation error "[...] is not a valid group by expression" is one of the compilation errors in Snowflake SQL. Here's what can cause the error (and an example of how to solve it).