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

12 March 2025
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

11 March 2025
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.

21 February 2025
Posts about : Tutorials (2)
Fix SQL Error 'is not a valid GROUP BY expression' in Snowflake | Census

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).
How to integrate Snowflake and Zapier | Census
1 November 2022
Need to get your data from Snowflake to Zapier? Check out this tutorial to help you manually set up the Snowflake-Zapier integration – or explore a better way.
How to unload data from Snowflake | Census

25 October 2022
If you want to retrieve your data from Snowflake, you're in the right place. Check out this tutorial to get started on your Snowflake data unloading journey.
Snowflake external functions for data enrichment with AWS example | Census

29 September 2022
Snowflake external functions unlock a whole new realm of possibility for the data platform. But what are they really? And, more importantly, how do you set them up? Here's everything you need to know.
Snowflake SQL API tutorial with authentication and query examples | Census

14 September 2022
Want to access your Snowflake data within your applications to boost its value? Snowflake is making it easier than ever to operationalize your data with the SQL API. Here's how to get started.
Three methods for sending data from BigQuery to Slack | Census

22 August 2022
How can you sync your data from BigQuery to Slack? We've got 3 methods to help you get your data from A to B: One manual, one automated using APIs, and one using Census rETL.
Redshift UNLOAD command: SQL, SDK, and CLI examples | Census

18 August 2022
How do you UNLOAD data from Amazon Redshift? We're laying out three examples, so you know exactly what options are available to you and how to execute them. Welcome to your complete guide to the Redshift unload command.
How to Move Data from Snowflake to Google Sheets | Census

5 July 2022
With no native integration, you have three options to get your data: Census, a Python script, and manually downloading and importing CSVs.
3 methods for moving data from Snowflake to Slack | Census

1 July 2022
Looking to get your data from Snowflake to Slack? Look no further! This tutorial will walk you through 3 methods of syncing data from A to B: one manual method, one method using APIs, and one using Census reverse ETL.
How to move data from Snowflake to Facebook Ads | Census

11 May 2022
Need to sync data from Snowflake to Facebook Ads? Look no further. We have three methods for moving your data from here to there in a snap.