Skip to content

Latest commit

 

History

History
46 lines (40 loc) · 1.85 KB

README.md

File metadata and controls

46 lines (40 loc) · 1.85 KB

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 git@github.com:clrcrl/jaffle_shop.git

If you need extra help, see these instructions.

  1. 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.

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

$ cd jaffle_shop
  1. Load the CSVs with the demo data set. This materializes the CSVs as tables in your target schema.
$ dbt seed
  1. Run the models:
$ dbt run
  1. Generate documentation for the project:
$ dbt docs generate
  1. 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: