@@ -41,3 +41,7 @@ tsconfig.tsbuildinfo
 **/.github/meta/pr-body-*.md
 .bridge-merge-report.md
 /data/
+
+# Rendered VHS demos — regenerable from .tape files, kept out of git
+docs/media/*.gif
+docs/reviews/AI-7520-code-pr1001-review-threads.md
@@ -0,0 +1 @@
+id: 03b8c7b7-4b26-4408-9876-88d05b7da4f5
@@ -0,0 +1,12 @@
+# Build/run artifacts that must NOT be committed. `target/*` (not `target/`)
+# so the re-include below actually works — git ignores the CONTENTS of target/
+# individually, then lets us un-ignore the one pre-compiled artifact we ship.
+# Using `target/` here would exclude the directory as a whole and make the
+# `!target/manifest.json` line inert (git will not descend into an ignored
+# directory to re-include children).
+target/*
+!target/manifest.json
+
+dbt_packages/
+logs/
+.user.yml
@@ -0,0 +1,55 @@
+# Jaffle Shop — altimate-code starter sample
+
+Everything below runs against a local DuckDB file — no cloud warehouse, no
+credentials, no network calls.
+
+## What's in here
+
+```
+dbt_project.yml         dbt project config
+profiles.yml            DuckDB profile — path is project-relative
+sample-manifest.json    version metadata used by altimate-code to detect
+                        stale copies on upgrade
+models/
+  staging/
+    stg_customers.sql   renames raw customer columns to snake_case
+    stg_orders.sql      renames raw order columns
+    schema.yml          column descriptions + unique/not_null tests
+  marts/
+    customers.sql       one row per customer, joins in order counts
+    orders.sql          one row per order, joins in customer names
+    schema.yml          column descriptions + tests + relationships
+seeds/
+  raw_customers.csv     3 rows of test data
+  raw_orders.csv        4 rows of test data
+target/
+  manifest.json         PRE-COMPILED dbt manifest — ships with the sample so
+                        altimate-code's static workflows (/discover, /review)
+                        work without dbt-core / dbt-duckdb installed
+```
+
+## What to try (works with zero external tools)
+
+- `/discover stg_customers` — walk the DAG and see what depends on this model
+- `/review models/marts/customers.sql` — run the reviewer against a mart model
+- Open any `.sql` file and ask altimate-code to explain the transformation
+- Ask altimate-code "what tests would you recommend for `orders`?"
+
+## What to try (needs `dbt-core` + `dbt-duckdb` installed)
+
+```bash
+pip install dbt-duckdb
+cd ~/altimate-sample-dbt         # or wherever you materialized the sample
+dbt seed                          # load the CSVs into DuckDB
+dbt build                         # run models + tests
+duckdb target/jaffle.duckdb -c 'select * from customers'
+```
+
+Once `dbt-duckdb` is on your `$PATH`, altimate-code detects it automatically
+and the "run" workflows appear in `/help`.
+
+## Bringing your own project
+
+When you're ready to switch to your real dbt project, `cd` into it and run
+altimate-code again. The scan will pick up your `dbt_project.yml` and offer
+to connect its warehouse.
@@ -0,0 +1,16 @@
+name: "jaffle_shop"
+version: "1.0.0"
+
+profile: "jaffle_shop"
+
+model-paths: ["models"]
+seed-paths: ["seeds"]
+target-path: "target"
+clean-targets: ["target", "dbt_packages"]
+
+models:
+  jaffle_shop:
+    staging:
+      +materialized: view
+    marts:
+      +materialized: table
@@ -0,0 +1,9 @@
+select
+    c.customer_id,
+    c.first_name,
+    c.last_name,
+    count(o.order_id) as order_count,
+    coalesce(sum(o.amount), 0) as total_amount
+from {{ ref('stg_customers') }} c
+left join {{ ref('stg_orders') }} o on c.customer_id = o.customer_id
+group by c.customer_id, c.first_name, c.last_name
@@ -0,0 +1,8 @@
+select
+    o.order_id,
+    o.customer_id,
+    c.first_name || ' ' || c.last_name as customer_name,
+    o.order_date,
+    o.amount
+from {{ ref('stg_orders') }} o
+join {{ ref('stg_customers') }} c on o.customer_id = c.customer_id
@@ -0,0 +1,32 @@
+version: 2
+
+models:
+  - name: customers
+    description: One row per customer with total order count and revenue.
+    columns:
+      - name: customer_id
+        description: Primary key.
+        data_tests:
+          - unique
+          - not_null
+      - name: order_count
+        description: Number of orders placed by the customer (0 when none).
+        data_tests:
+          - not_null
+      - name: total_amount
+        description: Sum of all order amounts (0 when none).
+        data_tests:
+          - not_null
+
+  - name: orders
+    description: One row per order with a joined customer name.
+    columns:
+      - name: order_id
+        description: Primary key.
+        data_tests:
+          - unique
+          - not_null
+      - name: customer_id
+        description: Foreign key to `stg_customers`.
+        data_tests:
+          - not_null
@@ -0,0 +1,27 @@
+version: 2
+
+models:
+  - name: stg_customers
+    description: Renamed customer columns from the raw seed.
+    columns:
+      - name: customer_id
+        description: Primary key of the customer.
+        data_tests:
+          - unique
+          - not_null
+
+  - name: stg_orders
+    description: Renamed order columns from the raw seed.
+    columns:
+      - name: order_id
+        description: Primary key of the order.
+        data_tests:
+          - unique
+          - not_null
+      - name: customer_id
+        description: Foreign key to `stg_customers`.
+        data_tests:
+          - not_null
+          - relationships:
+              to: ref('stg_customers')
+              field: customer_id
@@ -0,0 +1,5 @@
+select
+    id as customer_id,
+    first_name,
+    last_name
+from {{ ref('raw_customers') }}
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+id: 03b8c7b7-4b26-4408-9876-88d05b7da4f5`