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

A Runner's Tale of Plantar Fasciitis

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

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

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

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

dbt seed: Data Warehousing and CSV Files

The following are a few points I have learned while working with seeds in my dbt project

Surf, Work, and Explore: A Web Scraping Exercise

Surf, Work, and Explore: A Web Scraping Exercise

I scrape data using python to find new countries with surf spots where you can work remotely from, ceteris paribus