Featured Posts
Introducing Sync Tracking: Enhanced Data Observability and Debugging
Sync Tracking is a powerful new feature in the Observability Toolkit that provides row-level visibility into every record synced in the last 14 days
Announcing Observability Lake: Extend Your Sync Data Retention and Gain Deeper Insights
Observability Lake allows you to use your own cloud storage to retain data, providing extensive historical records and complete visibility into all sync data
Announcing GPT Columns: Clean, Categorize and Enrich in Seconds
Write AI-powered columns to your warehouse without code
Using SQL to create segments based on geo locations
Census Audience Hub is built from the ground up to run on your data warehouse, so you can directly write SQL to create segments in addition to using the UI
What Does the Digital Markets Act (DMA) Mean for Digital Marketers?
Digital Markets Act 101: A marketer's guide to understanding Europe’s landmark regulation and what it means for your digital marketing playbook.
Transforming data Before Syncing with Census Datasets
Transform and activate your data seamlessly with Census Datasets. Learn how to create, segment, and sync audiences across multiple platforms effortlessly.
(Pt 3) Right time: Triggering time-sensitive emails with event data in HubSpot
Increase revenue by sending HubSpot emails at a relevant time using data in your data warehouse.
(Pt 2) Right message: Personalizing emails with product usage data in HubSpot
Data teams can drive revenue by helping marketing teams create sophisticated HubSpot email personalization with product usage data.
(Pt 1) Right person: Targeting active trial users with product data in HubSpot
Want to demonstrate you can drive revenue as a data team? Help your marketing team target active trial users in their Hubspot campaigns.
How to solve the unexpected ‘’ 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.
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.
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.
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).