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.

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.

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.

3 Data Engineering Quick Fixes When You Hit An Optimization Ceiling

Use the 3 Rs of optimization to smash through technical barriers.

4 BigQuery Metadata SQL Queries To Save You Time, Money & Sanity

Never write another schema, save on storage costs and more.

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.

SQL Users: Reduce Your CASE Statements With A Lookup Table

Map fields in your SQL tables without using CASE.

Write Your First SQL ETL Pipeline (Part I)

You’ve written enough queries; it’s time to move to production.

Write Your First SQL ETL Pipeline (Part II)

How to create and load an aggregate table for your GCP usage using ETL principles and SQL commands.

Flattening Your SQL Tables — Not As Easy As It Sounds

How to expose deeply nested SQL fields — and why you need to be careful when handling complex raw data.

Stream Your Data Using Nothing But Python’s Requests Library

Understand when to stream data, how to configure a pipeline and learn from my mistakes building streaming pipelines.

How I’m Using Data Engineering To Help A Wall Street Banker Pick Better Stocks (Part I)

How a conversation between friends turned into a potentially lucrative data side project (with code walkthrough).