```json { "classifications": [ { "column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values for each row (514 distinct in 514 rows)" }, { "column": "tables_catalog_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key reference to tables_catalog table (514 distinct values, no nulls)" }, { "column": "table_type", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (6 distinct values: DIMENSION, EVENT, MISC, PATH, STATE) used for grouping/filtering" }, { "column": "table_type_reasoning", "role": "attribute", "confidence": 1.0, "reason": "Free-form descriptive text explaining classification logic (421 distinct values, long text)" }, { "column": "primary_key", "role": "attribute", "confidence": 0.9, "reason": "Descriptive field storing primary key column name(s) from classified table; displayed but not aggregated" }, { "column": "confidence", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (3 values: HIGH, LOW, MEDIUM) used for filtering/grouping" }, { "column": "confidence_note", "role": "attribute", "confidence": 1.0, "reason": "Free-form explanatory text for confidence level (5 distinct values, long descriptive content)" }, { "column": "model_name", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (3 distinct values) identifying the ML model used" }, { "column": "latency_ms", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (milliseconds) suitable for aggregation (avg/sum/min/max latency)" }, { "column": "token_usage_json", "role": "attribute", "confidence": 0.95, "reason": "JSON string containing structured metadata; displayed but not directly aggregated (257 distinct values)" }, { "column": "created_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp field used for temporal filtering, grouping, and slicing (514 distinct values)" } ] } ```