Level-Up Your SQL WHERE Clause & Filter On This Complex Data Type

SQL WHERE clauses don’t just need to filter on one row of data; walk through a complex SQL problem step-by-step.

Writing Your First DAG? Use SQL For More Accurate Data Availability Checks

Avoid the dreaded problems of data downtime and duplication by using simple SQL queries to establish data availability.

Using Gmail’s Python API To Delete 10,000 emails In Less Than Two Minutes (Pt. I)

Never manually delete emails again with this script integrating Python and Google Cloud Platform’s Gmail API.

The Simple Networking Spreadsheet I Wish I Used To Land A Data Job

A simple spreadsheet for data science job seekers to leverage your existing network to optimize your job search.

How Not To Annoy Senior Developers — Sincerely, A Senior Data Engineer

Proactive strategies covering how not to annoy your senior data scientists, engineers or developers from a senior’s perspective.

Using BigQuery SQL To Prettify Your Ugliest URLs And Extract Insights

Learn BigQuery SQL techniques to extract only the most relevant elements of your ugliest URLs.

Packaging And Remote Installation With Pip, Python & Artifact Registry

Neatly package and securely store Python packages in Python repo with Google Cloud’s Artifact Registry for your cloud builds.

The Subtle Power Of SQL’s Overlooked DML Function

One function you gloss over has the power to save you hours of development time — and preserve data accuracy.

How I Used Python & SQL To Build A Looker Dash During A Baseball Game

The 35 line SQL Query That Powers A Top 3 SQL Publication’s Analytics (Part II).

I Lost 3 Days Of Data By Not Taking 10 Min. For These Deprecation Steps

How data engineers can anticipate, adapt to and recover from inevitable data downtimes and API outages.

If You Must Use A Spreadsheet As A Database At Least Use This Kind

Spreadsheets are a breeding ground for data inaccuracy — unless you can solve one core problem.

Using PyPDF For PDF →CSV Conversion To Find Missing Groceries

Convert PDFs to CSVs in an unusual–but practical–use case of real-life data engineering problem-solving.