Automate Your BigQuery Schema Definitions With 5 Lines of Python
Tired of manually writing my BigQuery schemas, I wrote a function that makes schema definition less time-consuming.
Zach Quinn
5 Portfolio-Worthy SQL Project Ideas for Beginners
Ideas to help you create projects that will wow future employers.
3 Data Science Projects That Got Me 12 Interviews. And 1 That Got Me in Trouble.
3 work samples that got my foot in the door, and 1 that almost got me tossed out.
A No-Fear Introduction to Working with SQL Nested & Repeated Fields
Making SQL nested and repeated data types more understandable — and less intimidating.
Create Your SQL Table Right the First Time Using These 6 Tips
Review this SQL professional’s check-list before running ‘CREATE TABLE.’
6 Things SQL Newbies Need to Realize Before Writing A Single Query
Breaking down the context behind your SQL queries.
cURLing: Converting cURL to Python with CurlConverter
Easily translate your pesky API’s cURL commands to Python.
Prettify Your Python Logs with Loguru
How an easy-to-use logger can format your log data output.
SQL Quality Assurance Queries
How to construct queries in SQL to confirm data accuracy.
How Many Hours Per Week Should Data Professionals Really Dedicate to Learning?
Here’s how much time you should dedicate to learning new skills both at work and off-the-clock, according to experts.
How to Use Python & SQL to Append New Rows to a BigQuery Table Without Overwriting Your Data
How to dynamically update rows in BigQuery using python and SQL without losing your historical data.
Cron-ological Order: How to Write Cron for Scheduling Pipelines
How to write cron expressions and why data engineers need to know them.