Generating Automated Headers In Looker For More Dynamic Reporting
In less than 10 minutes create a Looker header that dynamically displays attributes — like the current month — for your users.
Zach Quinn
Create Your ETL Pipeline In 90 Min. (A Best Case Scenario)
Creating a data engineering pipeline using Python, SQL and Google Cloud in less than 2 hours.
Picking The Wrong SQL Join Key Cost Me Weeks Of Accurate Data. Don’t Let It Happen To You.
Even if you’re choosing the correct SQL JOIN, you could still make a tiny mistake that could cost you — or your org — big time.
Write Your First ETL Pipeline (Part III)
Take a SQL script from a SQL environment to Google Cloud Platform by introducing a dynamic data check and upload step.
Everything Your Cloud Provider Won’t Tell You About Service Accounts
Learn service account logic, use cases and the unavoidable business problem they solve.
Stop The Bleeding: 4 Strategies To Troubleshoot, Triage Data Anomalies
Quickly identify, isolate and fix malfunctioning data pipelines for quality data, happier stakeholders and a stress-free workday.
Stop Writing Queries When You Need To Be Writing Views (With Examples)
Reduce the complexity and execution time of your queries with views for cleaner data and happier stakeholders.
Overcoming The Final Hurdle of Data Automation With Fewer Failures
Learn the components of data pipeline production to take your ETL build from code to cloud with automated, actionable results.
Track API Usage In Your Python Script — Not Your Credit Card Bill
In 5 lines of Python store information about requests, timestamps and status flags to avoid unexpected API charges.
Yes, You Can Edit Schemas In BigQuery–But Not How You Think
A hacky workaround for one of the biggest problems in SQL.
How You Can Use Python To Pull Stock Data For 3,000 Companies In Under 10 Minutes
How I used python to help a Wall Street banker pick stocks (part II).
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).