About the Jaffle Shop warehouse

Teradata Developer Guides
ft:locale
en-US
ft:lastEdition
2026-08-18

jaffle_shop is a fictional e-commerce store. This dbt project transforms raw data from an app database into a dimensional model with customer and order data ready for analytics.

The raw data from the app consists of customers, orders, and payments, with the following entity-relationship diagram:

customers customers id   [int] first_name   [varchar] last_name   [varchar] email   [varchar] orders orders id   [int] user_id   [int] order_date   [date] status   [varchar] customers--orders 0..N 1 payments payments id   [int] order_id   [int] payment_method   [int] amount   [int] orders--payments 0..N 1

dbt takes these raw data tables and builds the following dimensional model, which is more suitable for analytics tools:

dimension: customers dimension: customers customer_id   [int] first_name   [varchar] last_name   [varchar] email   [varchar] first_order   [date] most_recent_order   [date] number_of_orders   [int] total_order_amount   [int] fact: orders fact: orders order_id   [int] customer_id   [int] order_date   [date] status   [varchar] amount   [int] credit_card_amount   [int] coupon_amount   [int] bank_transfer_amount   [int] gift_card_amount   [int] dimension: customers--fact: orders 0..N 1