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
Hi there! My name is Paulo and I am an analytics/data engineer and endurance runner based in Berlin. Welcome to my blog.
When I am not building data pipelines, you will find me training for my next endurance race. I write about both.
Currently preparing for Spartathlon 2026 and documenting the journey in my 246 series.
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
A brief introduction to exposures and why they should be in every dbt project
The Nomad Work
A list of spots where to do some remote work
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
Cool dbt Feature: Project Variables
A brief introduction to project variables and their benefit when modeling in dbt
Creating Tables with LOBs using dbt in Azure Synapse: The Columnstore Index Error
A work-around to the default settings when creating tables using the dbt-synapse adapter
A Runner's Tale of Plantar Fasciitis
The story of a rollercoaster ride dealing with foot inflammation and my journey back to running
Understanding DAGs in dbt: Threads, Errors and Failing Fast
Three scenarios show us the implications of running a Directed Acyclic Graph (DAG) in multi-threaded dbt environments, shedding light on how errors and the "fail fast" argument impact model execution