Featured Posts
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
Why we chose Iceberg as the foundation for Census Store
Why Iceberg makes object storage work, and how we're making Census more efficient with Census store
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.
How to build external data sharing pipelines for your customers
Census Embedded is the best way to securely import or export external customer data by providing pre-built SaaS integrations to hundreds of tools.
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 ‘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.
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.