Skip to content

emilieschario/jaffle_shop

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:


About

Data for dbt tutorial

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published