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
Hi there! My name is Paulo and I am an analytics/data engineer and endurance runner based in Berlin, Germany. Welcome to my blog.
Blog
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