Koen Verbeeck in General Analytics Scripting Dimension Tables with dbt Macros: Type 1 and Type 2 SCD Patterns for Data Warehouses Building dimension tables with dbt macros - Type 1 (overwriting changes) and Type 2 (preserving history with effective dates) slowly... 16 July 2025 9 min read
Koen Verbeeck in General Analytics Loading a Date Dimension in Microsoft Fabric Warehouse with dbt Macros: Complete Tutorial with Generated Calendar Table Building a date dimension table in Microsoft Fabric Warehouse using dbt macros - generating date rows with dbt's sequence utilities,... 23 April 2025 7 min read
Koen Verbeeck in General Analytics Loading Models from Source Data with dbt The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses... 20 January 2025 8 min read
Koen Verbeeck in General Analytics A gentle introduction to dbt In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract... 10 December 2024 12 min read 11
