dbt models for jaffle_shop

jaffle_shop is a fictional ecommerce store. This dbt project is for demonstrations and tutorials.

Running this project

To play with the project yourself:

1. Install dbt using these instructions.
2. Clone this repository using:

$ git clone [email protected]:clrcrl/jaffle_shop.git

If you need extra help, see these instructions.

3. Set up a profile called jaffle_shop using these instructions. You can run this in a new schema in your existing data warehouse, or even setup a local postgres database to run this.

4. Change into the jaffle_shop directory from the command line:

$ cd jaffle_shop

5. Load the CSVs with the demo data set. This materializes the CSVs as tables in your target schema.

$ dbt seed

6. Run the models:

$ dbt run

7. Generate documentation for the project:

$ dbt docs generate

8. View the documentation for the project:

$ dbt docs serve

What is a jaffle?

A jaffle is a toasted sandwich with crimped, sealed edges. Invented in Bondi in 1949, the humble jaffle is an Australian classic. The sealed edges allow jaffle-eaters to enjoy liquid fillings inside the sandwich, which reach temperatures close to the core of the earth during cooking. Often consumed at home after a night out, the most classic filling is tinned spaghetti, while my personal favourite is leftover beef stew with melted cheese.

---

For more information on dbt:

• Read the introduction to dbt.
• Read the dbt viewpoint.
• Join the chat on Slack for live questions and support.

---