Featured Posts
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.
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?
Write to custom contact records w/ the HubSpot API | Census
Frustrated you can't leverage all your data in HubSpot? Here's a quick & dirty guide to writing to custom contacts w/ the HubSpot API & Python.
How to Hack It: Postgres to Google Sheets w/ Python | Census
Need to move all your customer data from Postgres into Google Sheets with Python? Here's a quick guide to get from A to B (and a shortcut).
Trigger syncs from DAGs w/ our Airflow Provider | Census
Sync scheduling shouldn't stress anyone out. That's why we're excited to announce our newest data orchestration improvement: the Airflow Provider.
Census officially SOC 2 Type 2 compliant | Census
We know customer data security is more important than ever. So we're excited to announce we're officially SOC 2 Type 2 compliant.
Essential SQL window functions for business operations | Census
Looking to take your SQL skills to the next level (and save some sanity)? It's time to tackle SQL window functions like ROW_NUMBER(), AVG(), and more.
Start small to build the modern data stack | Census
You don't need to build the entire modern data stack to get more out of your data. You make progress on your data journey with the smallest step.
The modern data stack = your business nervous system | Census
We often talk about the warehouse as the brain of your business, but it takes a full nervous system of tooling to make the modern data stack possible. Check out the unique role each tool plays in turning your data into action.
Pipedrive API w/ Python tutorial: Contact records | Census
Want to use Pipedrive as your sales CRM, but need to get data from other sources into it? You can hack it with the Pipedrive API and python.
Lessons from our Operational Analytics Conference | Census
Our inaugural Operational Analytics Conference came with a lot of operational and topical lessons. Here's what we learned.
How Data Orchestration Unleashes the Full Power of Your Data
Is your team using the freshest data possible? Master the art of data orchestration to streamline, automate and empower your data pipelines.