"This column contains the status"
- name: status
description: "The status of the record"
tests:
- not_null
"TODO: add description"
- name: dim_customers
description: "TODO: add description"
columns:
- name: customer_id
description: "TODO"
- name: segment
description: "TODO"
- name: ltv_score
description: "TODO"
"Ask Brian, he knows"
-- The logic for churn calculation
-- is complicated. Ask Brian in
-- the revenue team for details.
--
-- Update: Brian left in Q3 2024.
"Updated: 2021-03-14"
## Data Dictionary
Last updated: 2021-03-14
| Column | Type | Description |
|----------|--------|-----------------|
| amount | FLOAT | The amount |
| type | STRING | 1=good, 2=bad |
Note: We added 15 new columns
since this was written.
"See Confluence page"
- name: fct_revenue
description: >
Revenue fact table. For business
logic see Confluence page
"Revenue Calculations v3 (FINAL)
(FINAL FINAL) (USE THIS ONE)"
# The page was archived 8 months ago
"Don't touch this"
-- DO NOT MODIFY THIS QUERY
-- I don't know why it works but
-- if you change anything the
-- numbers will be wrong.
-- Trust me. I spent 3 days on this.
--
-- - Someone, probably 2022
"The auto-generated masterpiece"
- name: crt_dt
description: "Created date"
- name: upd_dt
description: "Updated date"
- name: crt_by
description: "Created by"
- name: del_flg
description: "Delete flag"
"The model that documented itself"
- name: stg_payments__v2_new_final
description: "Staging model for
payments. Replaces
stg_payments__v2_new which
replaced stg_payments__v2 which
replaced stg_payments."
# All four models are still running
"AI-generated, human-ignored"
- name: dim_customers
description: >
This table stores customer data.
customer_id is a unique identifier
for each customer. created_at is
the timestamp when the record was
created. updated_at is the timestamp
when the record was last updated.
# 200 words. Zero business context.
"The agent that confidently lied"
- name: status
description: >
Customer lifecycle status.
1 = Active, 2 = Churned,
3 = Suspended, 4 = VIP
# Actual values: 1-17.
# Nobody knows what 5-17 mean.
# The agent guessed from column name.
"Generated by Copilot, reviewed by nobody"
- name: fct_orders
description: "Orders fact table"
- name: fct_payments
description: "Payments fact table"
- name: fct_shipments
description: "Shipments fact table"
- name: fct_returns
description: "Returns fact table"
# 47 models. Same pattern. Ship it.
"Your AI agent has no memory"
Session 1: "status=3 means churned"
Session 2: "what does status=3 mean?"
Session 3: "status=3 means churned"
Session 4: "what does status=3 mean?"
Session 5: "status=3 means churned"
# Every session starts from zero.
# The agent learns nothing.