The Nomad Work
A list of spots where to do some remote work
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.
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
Taking snapshots using dbt in Azure Synapse: The Hash Distribution Issue
Learn how to troubleshoot and resolve the "Hash Distributed Table" error when taking snapshots using dbt in Azure Synapse Dedicated Pool
Understanding DAGs in dbt: Erring Models and Failing Tests
Three scenarios shows us what happens downstream when our models and/or tests do not succeed
dbt seed: Data Warehousing and CSV Files
The following are a few points I have learned while working with seeds in my dbt project