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.
Zach Quinn
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.
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.
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.
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.
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.
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.
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.
Talk With Your APIs, Not At Them
Reduce failed API requests by taking the time to “listen” to your API responses and — other pointers to improve your API conversation…
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.
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.