Featured Posts

Introducing Census SaaS Datasets: Connect, Transform, and Activate Your SaaS Data
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
Ellen Perfect
12 March 2025
Why we chose Iceberg as the foundation for Census Store
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
Ellen Perfect
11 March 2025
Two Ways to Enrich Directly in the Warehouse
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.
Ellen Perfect
21 February 2025

Posts about : Tutorials (2)

Tutorials (2)
Fix SQL Error 'is not a valid GROUP BY expression' in Snowflake | Census
Roel Peters
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).
Tutorials (2)
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.
Tutorials (2)
How to unload data from Snowflake | Census
Michel Zurkirchen
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.
Tutorials (2)
Snowflake external functions for data enrichment with AWS example | Census
Stephen Allwright
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.
Tutorials (2)
Snowflake SQL API tutorial with authentication and query examples | Census
Stephen Allwright
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.
Tutorials (2)
Three methods for sending data from BigQuery to Slack | Census
Michel Zurkirchen
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.
Tutorials (2)
Redshift UNLOAD command: SQL, SDK, and CLI examples | Census
Volodymyr Grin
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.
Tutorials (2)
How to Move Data from Snowflake to Google Sheets | Census
Volodymyr Grin
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.
Tutorials (2)
3 methods for moving data from Snowflake to Slack‍ | Census
Michel Zurkirchen
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.
Tutorials (2)
How to move data from Snowflake to Facebook Ads | Census
Michel Zurkirchen
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.