Live JSON
{ "domain": "", "difficulty": "", "db_type": "", "instruction": "", "context": "", "required_metrics_kpis": [], "aggregation_logic": {}, "chain_of_thought": [], "data_model": { "facts": "", "dims": "", "hierarchies": "", "aggrs": "", "snapshots": "" }, "sql": "" }
1 · Meta
2 · Business Question
3 · Business Context
4 · Metrics & Aggregation
KPI / Metric Name*Aggregation Formula
5 · Chain of Thought
Optional
1
Add steps to document the AI's reasoning process
6 · Schema Tables
Fact Tables*
Dimension Tables*
7 · Data Model Layers
8 · SQL Answer
Optional