Trusty codes

When adding new records, data warehouses often set a field that denotes when data was ingested. This helps with tracking changes to data over time, and removing duplicates. In this tutorial, you’ll first learn how to set a synced_at column in #BigQuery and beyond with #SQLAlchemy. [Read More]

“Don’t Repeat Yourself” (DRY) is one of the most famous adages in software development. The principle advises us not to represent information in multiple places. Data warehouses present a challenge to applying DRY, because they inherently allow for the possibility of duplicate records. How then do we tackle the problem... [Read More]

Serverless computing is an excellent approach when you just want to run simple code on the cloud. without needing to consider hardware scaling. This tutorial shows how you can easily deploy code to Google Cloud Run with Docker and Python. Before you start, make sure that you have Docker Desktop... [Read More]

Type hinting in Python allows you to annotate the data type of variables and functions. While type hinting is not required for the dynamically typed language, this feature enables intelligent type suggestions, type checking with mypy, and improved code clarity. In a recent scenario, I encountered the need to type... [Read More]