With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal to write SQL more efficiently. One of those features is macros, which we’ll introduce in this article (don’t worry; they’re not related to the Excel VBA macros of your nightmares).
The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse. The article Loading Models from Source Data with dbt expands this setup further by