Monthly Recurring Revenue (MRR) playbook.

This dbt project is a worked example to demonstrate how to model subscription revenue. Check out the full write-up here, 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.

The SQL in this project is compatible with Snowflake¹.

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.