Blog

Everything I have written on data engineering, analytics and running since 2020.

Running the Transgrancanaria Classic Ultra

Running the Transgrancanaria Classic Ultra

An account of unexpected challenges and forging unlikely friendships during the grueling trail ultramarathon across Gran Canaria

Working with dbt in VS Code

Working with dbt in VS Code

A brief description of features from CSV Rainbow and dbt Power User, both extensions for VS Code

Cleaning Up Deprecated Models using dbt in Azure Synapse

Cleaning Up Deprecated Models using dbt in Azure Synapse

Use custom macros to remove deprecated tables and views from your target schema

Top 10 Books Read in 2023

Top 10 Books Read in 2023

Selected quotes from what I considered were the best books I read/listened to in 2023.

Pausing dbt Resources after Pipeline Retirement

Pausing dbt Resources after Pipeline Retirement

A summary of three ideas on pausing dbt resources: leveraging the exclusion flag, disabling resources, and transforming models into analyses

Creating Date Dimensions using dbt in Azure Synapse: Custom Macros

Creating Date Dimensions using dbt in Azure Synapse: Custom Macros

A custom macro to create date dimensions when using the dbt-synapse adapter

Cool dbt Feature: Exposures

Cool dbt Feature: Exposures

A brief introduction to exposures and why they should be in every dbt project

The Nomad Work

The Nomad Work

A list of spots where to do some remote work

Berlin Marathon Data: 1974-2023

Berlin Marathon Data: 1974-2023

Berlin Marathon results among runners from 1974 to 2023, including data from Kaggle for the years 1974-2019 and additional results from 2021-2023