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.
Quick guide: SQL aggregate functions | Census
Looking to do more with your data? Just need a refresher on how SQL aggregate functions work? We got you.
How to Connect Snowflake with Python (Jupyter) Tutorial | Census
In this end-to-end example, you'll learn how to query Snowflake with Python and manipulate the data in a Jupyter notebook. `pip install snowflake-connector-python` and get started!
Connect to BigQuery with the Python API Client + Example Script | Census
Get started with the BigQuery API in this step-by-step tutorial! You’ll learn how to set up the BigQuery API Client, query your data, and send it to Google Cloud Storage as a CSV file.
Load data from Snowflake to Hubspot
Want to move your data from Snowflake to Hubspot? Check out these step-by-step methods to learn how to get your data from A to B.
How to automate custom Fantasy Football logic | Census
Love data and football? Check this out to upgrade your Fantasy Football game to a whole new league with reverse ETL.
4 Ways to Move Data from Snowflake to Salesforce (w/ Examples)
Looking to move your data from A (Snowflake) to B (Salesforce) without pulling all your hair out? Check out this tutorial with screenshots and sample code.
How to use SQL for geographic place recommendations | Census
Did you know you can set up geographic place recommendations with SQL and the haversine formula? Well, you do now. Here's how.
4 methods for exporting CSV files from Databricks | Census
Trying to find a way to pull your data out of Databricks as a CSV? Look no further. Here are four ways you can get the job done.
3 Methods for Exporting CSV Files from BigQuery | Census
Did you know you can export a CSV from BigQuery? Read on to learn how to export using BigQuery console export, bq command-line tool, and client library.
4 methods for exporting CSV files from Redshift | Census
Whether you're Redshift superuser or a newcomer, you'll run into a reason to export CSV files. Here are four solid ways to get the job done.