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?
Streamline Data Processes with the Data Engineering Lifecycle | Census
Understanding the data engineering lifecycle helps every role on the team perform better and get the results they're after. Check out this SCD session recap to learn how.
Snowflake + SQLAlchemy Tutorial: Installation & Example Queries | Census
SQLAlchemy is one of the most popular libraries to interface with relational databases in Python. So how can you leverage this to interface with Snowflake? Check out this step-by-step tutorial.
Tipping points: How individual decisions make big impacts in data careers & data teams | Census
All of our careers (and the collective careers of our data teams) are the sum of critical decisions made at the right or wrong time. Drizly's data team grew 7x in just 3 years. Here's how.
Diversity in data: Modeling a better future for data teams | Census
When it comes to data, as with all other industries, diversity is crucial. Check out this SCD keynote recap to hear some steps you can take to make your data team more diverse.
Stars, tables, and activities: How do we model the real world? | Census
For 25 years, Ralph Kimball and Margy Ross’s The Data Warehouse Toolkit has provided the mainstream method of data modeling. But is it still relevant? Or is there another alternative?
Operational analytics in B2B startups | Census
Operational analytics empowers organizations, but there are trade-offs between the amount of data you have & its value. Check out this SCD session recap featuring SpatialChat's journey to OA.
Server-side tag manager or reverse ETL: Which one should you use? | Census
How are server-side tag managers and reverse ETL different? How are they similar? Can you use both in your data stack? Here are the answers to these questions and more.
Fix SQL Error 'is not a valid GROUP BY expression' in Snowflake | Census
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).
Webinar recap: How Figma operationalizes data across their $20B PLG business | Census
Figma has seen huge success due to their PLG motion. Check out what Praveer Melwani, CFO at Figma, had to say about how they operationalized data to drive revenue across their $20B PLG business.
dbt or data business transition: Reflecting on this year’s Coalesce highlights | Census
As dbt adoption is rising, we were expecting a lot from Coalesce 2022 – and it didn't disappoint. Here are the highlights of some of our favorite moments from this year's event.