Featured Posts
Introducing Sync Tracking: Enhanced Data Observability and Debugging
![Introducing Sync Tracking: Enhanced Data Observability and Debugging](https://cdn.letterdrop.co/images/2024/8/30/getcensus/4236ov/Sync_Tracking_blog_header.webp)
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
![Arjit Jaiswal](https://www.getcensus.com/hubfs/arjit.jpeg)
30 August 2024
Announcing Observability Lake: Extend Your Sync Data Retention and Gain Deeper Insights
![Announcing Observability Lake: Extend Your Sync Data Retention and Gain Deeper Insights](https://cdn.letterdrop.co/images/2024/8/30/getcensus/oyhg3b/Blog_header_Observability_Lake.webp)
Observability Lake allows you to use your own cloud storage to retain data, providing extensive historical records and complete visibility into all sync data
![Arjit Jaiswal](https://www.getcensus.com/hubfs/arjit.jpeg)
29 August 2024
Announcing GPT Columns: Clean, Categorize and Enrich in Seconds
![Announcing GPT Columns: Clean, Categorize and Enrich in Seconds](https://cdn.letterdrop.co/images/2024/8/21/getcensus/hrta7a/GPT_Columns_updated.webp)
Write AI-powered columns to your warehouse without code
21 August 2024
Posts about : Tutorials
Using SQL to create segments based on geo locations
![Sean Lynch](https://www.getcensus.com/hubfs/Imported_Blog_Media/sean-lynch_profile.png)
30 August 2024
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?
![Katy Yuan](https://www.getcensus.com/hubfs/Imported_Blog_Media/63d4846abca01950f4ecaf2f_Katy-Yuan-profile-Jul-05-2023-07-13-03-8454-PM.jpeg)
2 August 2024
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
![Sylvain Giuliani](https://www.getcensus.com/hubfs/Imported_Blog_Media/sylvain-giuliani_profile.png)
29 May 2024
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
![Jeff Sloan](https://www.getcensus.com/hubfs/Imported_Blog_Media/jeff-sloan_profile.png)
26 September 2023
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
![Jeff Sloan](https://www.getcensus.com/hubfs/Imported_Blog_Media/jeff-sloan_profile.png)
24 August 2023
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
![Jeff Sloan](https://www.getcensus.com/hubfs/Imported_Blog_Media/jeff-sloan_profile.png)
23 August 2023
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
![Sooter Saalu](https://www.getcensus.com/hubfs/Imported_Blog_Media/authors/sooter-saalu.png)
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.
How to Fix SQL Compilation Error: Missing Column Specification | Census
![Furqan Butt](https://www.getcensus.com/hubfs/Imported_Blog_Media/authors/furqan-butt.png)
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.
Snowflake + SQLAlchemy Tutorial: Installation & Example Queries | Census
![Roel Peters](https://www.getcensus.com/hubfs/Imported_Blog_Media/Roel-Peters-profile.jpeg)
23 November 2022
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
![Roel Peters](https://www.getcensus.com/hubfs/Imported_Blog_Media/Roel-Peters-profile.jpeg)
8 November 2022
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).