Featured Posts
Understanding Gemini: Costs and Performance vs GPT and Claude
See how Gemini's flash and pro models measure up against GPT and Claude, and understand which ones to use for which tasks.
GPT vs Claude: What's The Best AI Model?
Which models are the most performant and cost effective? Which win at what use cases?
Product-Led Growth With Claude: Turning User Events into Customer Insights
Use product usage metrics to predict next best actions with Claude and Census GPT Columns
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.