Hi there! My name is Paulo and I am a freelance data all-arounder based in Berlin, Germany. Welcome to my blog.

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