AI, Vibe coding, Web development, GamesVibe coding a game in 2026 as a data engineerThe Ceiling of my vibes: Building a Game with LLMs when you are not a game developer If you read my other blog posts, or know me well enough…
Database, Generative AI, Oracle, DB2, SQL ServerIf databases were rappers (thoughts from a Generative AI)If databases were rappers (thoughts from a Generative AI) Can you relate to these? Following from my previous posts where we explored what…
Business Intelligence, Software Development, Web DevelopmentImplementing a component based design system in PowerBIImplementing a Component-Based Design System in Power BI Standard Power BI headers, buttons, and callouts often feel disconnected from an…
Business Intelligence, Software DevelopmentPower BI PBIP Git version controlHow to commit a Power BI report to Git The files from this blog post can be accessed here: https://github.com/mortie23/pbip-nfl/pull/…
Web Development, Python, CloudLoan Logic, an application to help with mortgage scenario modellingLoan Logic: A Mortgage scenario modelling application Background I have always been interested in financial modelling and how different…
Data Engineering, Python, TeradataLoad to Teradata with a Python wrapper for TPTPyTPT: A Python Wrapper for High-Performance Teradata Data Loading This blog post is paired with the associated Github repository https…
Cloud Infrastructure, Generative AI, AWS, Azure, GCPIf cloud platforms were people (thoughts from a Generative AI)Can you relate to these? As of writing this blog post, I have been really enjoying the new releases in Google’s Gemini AI for both images…
Cloud Infrastructure, Data Engineering, Python, DuckDBQuackpipe, running DuckDB local and on AWS GlueQuackpipe Stop waiting for AWS Glue jobs while in development by using a local-first workflow with DuckDB and deploy with Terraform. Your…
Cloud Infrastructure, Data Engineering, Python, SalesforceQuery Salesforce with PythonQuery SalesForce objects with Python Ever found yourself exporting data from Salesforce using the Web UI over and over again. Ever wished…
Python, Data Science, Software DevelopmentPublishing a Python Streamlit app to Posit ConnectPython applications published to Posit Connect This is a simple Streamlit application structured as a modular project and managed using…
Cloud Infrastructure, Data Engineering, GCP, Machine Learning, Python, Software EngineeringMaking Machine Learning predictions from BigQuery DataformNFL Touchdown Prediction with Dataform and BigQuery ML This blog post demonstrates how to build an end-to-end ML pipeline using Google Cloud…
Cloud Infrastructure, Data Engineering, GCP, Machine Learning, Python, Software EngineeringThe Tale of Two Routes: A Love Story Between BigQuery and Vertex AI for Machine Learning predictionsThis blog post is the first, and probably last where I thought I would see what the Github Copilot VSCode extension could do with writing a…
Cloud Infrastructure, MLOps, Machine Learning, PythonGCP Serverless prediction service using Cloud Run from a Vertex AI modelDeploying ML Models on Cloud Run: From Placeholder to Production This guide walks through deploying a machine learning model on Google Cloud…
Cloud Infrastructure, Data Engineering, DevOpsChecking the public IP address of a GCP Cloud FunctionPublic IP address of a GCP Cloud Function When you deploy a Cloud Function without configuring a VPC, it operates within Google’s internal…
Generative AI, Software EngineeringIf programming languages were people (thoughts from a Generative AI)Can you relate to these? Inspired from these (https://leftoversalad.com/c/015_programmingpeople/), let’s see what a Generative AI thinks of…
Cloud Infrastructure, Data EngineeringDebugging Dataform with Node.js in VScodeDebugging Dataform with Node.js in VScode Debugging Dataform JavaScript If you happen to be a data engineer who is not familiar with the…
Cloud Infrastructure, Data EngineeringGCP Cloud Functions for Web Scraping AFL dataScraping web data using GCP Cloud Functions The main reason for this blog post is a practical example of writing a GCP Cloud Function with…
Software Development, Data Science, PythonFlask application with custom package deployed to GCP Artifact Registry and Cloud RunFlask application with custom package deployed to GCP Artifact Registry and Cloud Run What we are looking to do in this example is…
Dataflow, Data Engineering, GCP, BigQueryConverting table schemas from any database to BigQuery for DataflowWhy do this? When using Dataflow Google-provided templates for any RDBMS to BigQuery (such as PostgreSQL to BigQuery) the target table in…