Archival Notice

This repository has been archived.

As a result all of its historical issues and PRs have been closed.

Please do not clone this repo without understanding the risk in doing so:

• It may have unaddressed security vulnerabilities
• It may have unaddressed bugs

Click for historical readme

Metrics Framework Playbook

This dbt project provides an example to demonstrate how to a metrics framework. Check out the full write-up (coming soon), as well as the documentation site for this project here.

Note that this project is not a package -- it is not intended to be installed in your own dbt project, but instead provides a good starting point for building similar data models for your own business.

Warehouse & SQL Flavor:

• Snowflake / ANSI

If you want to run this project yourself to play with it (assuming you have dbt installed):

1. Clone this repo.
2. Create a profile named playbook, or update the profile: key in the dbt_project.yml file to point to an existing profile (docs).
3. Run dbt deps.
4. Run dbt seed.
5. Run dbt run -- if you are using a warehouse other than Snowflake, you may find that you have to update some SQL to be compatible with your warehouse.
6. Run dbt test.

---

1. We decided to not make the SQL multi-warehouse compatible since this project is intended to be a demonstration, rather than a package. Making this project multi-warehouse compatible would complicate the SQL.