1 — Meta Information
Entry ID (q_id):#1auto-assigned
2 — Business Question
3 — Business Context
4 — Required Metrics & KPIs
5 — Aggregation Logic
Map each metric name → aggregation formula
6 — Chain of Thought
Document each reasoning step the model takes to produce the SQL.
1
7 — Fact Tables
8 — Dimension Tables
9 — Data Model Layers
10 — SQL AnswerOptional
Live JSON Preview
Live
{
  "q_id": 1,
  "domain": "",
  "difficulty": "",
  "db_type": "",
  "instruction": "",
  "context": "",
  "required_metrics_kpis": [],
  "aggregation_logic": {},
  "chain_of_thought": [
    "Step 1: Others"
  ],
  "data_model": {
    "facts": "",
    "dims": "",
    "hierarchies": "",
    "aggrs": "",
    "snapshots": ""
  },
  "sql": ""
}