Cleaning Up Deprecated Models using dbt in Azure Synapse
Use custom macros to remove deprecated tables and views from your target schema
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.
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
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
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