Write Your First SQL ETL Pipeline (Part I)
You’ve written enough queries; it’s time to move to production.
Zach Quinn
SQL Users: Reduce Your CASE Statements With A Lookup Table
Map fields in your SQL tables without using CASE.
Measuring Impact As A Data Engineer
How data engineers can more accurately trace the impact of your data, your work and your team within your organization.
4 BigQuery Metadata SQL Queries To Save You Time, Money & Sanity
Never write another schema, save on storage costs and more.
3 Data Engineering Quick Fixes When You Hit An Optimization Ceiling
Use the 3 Rs of optimization to smash through technical barriers.
Data Scientists: Answer 6 Questions to Summarize Your Insights In 1 Sentence
A simplified writing technique to help you communicate complex data science problems, describe methods and share results.
So, You Think A Company Misused Your Data. How To Write A DSAR.
Learn how to audit a company for your user data, request data suppression or even request total deletion — all in one email.
Don’t Get Cocky: 5 Confidence Shortcuts That Will Break Your Production Pipelines
As you gain proficiency, you gain confidence; this can lead to cutting corners — and the potential to make big mistakes.
Scrape, Clean and Store Zillow Apartment Data — Part II
Store data scraped from Zillow in a BigQuery table and view.
Scrape, Clean and Store Zillow Apartment Data (ETL Pipeline)
Use Python to find an apartment on Zillow.
Backfill Your SQL Tables Without Breakage Before Anyone Finds Out You Were Wrong
Re-loading missing data will be one of the least glamorous but most important tasks you do as a SQL developer. Get it right.
5 Ways to Use Python to Boost Your SQL Operations
Overcome SQL’s limitations with these Python methods.