This page lists the dbt packages useful to build a Pragmatic Data Platform (PDP) with dbt.

These first two packages contain the core macros to set up a new project and to code your data projects with the PDP patterns. Created by the creator of the PDP.

Snowflake Project Admin package

The Snowflake Project Admin package is a lightweight, opinionated package to quickly set up new dbt projects according to the PDP best practices.

It has been created with the goal to get a new dbt project up and running in minutes, while fully following the PDP governance.

Pragmatic Data Platform package

The Pragmatic Data Platform package contains a set of macros that can be imported in any dbt project to build a pragmatic data platform as described in my books: “Data Engineering with dbt” and “Building A Pragmatic Data Platform with dbt and Snowflake”.

The macros mostly cover ingestion, staging, historicization and version management. The storage layer is in fact mostly (99%) built by automation and metadata. This makes it easy to build even for less experienced developers and very stable.

The package also includes macros for the Refined layer, like performing full history time-joins, and for the Delivery layer, like the Self Completing Dimension.

Please note that this package is released under a dual license, mostly to limit free use by competing consulting companies. It can be used freely for internal projects also in commercial settings.

Other useful packages

dbt utils package
The ubiquitous package from dbt Labs themselves, providing lots of useful extension to the core dbt functionalities, from new tests to loading data from the data platform.