Featured Posts
Introducing Sync Tracking: Enhanced Data Observability and Debugging
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
Announcing Observability Lake: Extend Your Sync Data Retention and Gain Deeper Insights
Observability Lake allows you to use your own cloud storage to retain data, providing extensive historical records and complete visibility into all sync data
Announcing GPT Columns: Clean, Categorize and Enrich in Seconds
Write AI-powered columns to your warehouse without code
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.
The 5 SQL date functions biz ops teams need to know | Census
Trying to figure out all the different SQL date functions out there? Follow a fictional company to learn 5 functions to help your business ops.