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).

Yes, You Can Edit Schemas In BigQuery–But Not How You Think

A hacky workaround for one of the biggest problems in SQL.

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.

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.

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.

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.

Everything Your Cloud Provider Won’t Tell You About Service Accounts

Learn service account logic, use cases and the unavoidable business problem they solve.

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.

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.

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.

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.

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…