```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, unique per row (514 distinct)" }, { "column": "table_type", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (6 values: DIMENSION, EVENT, MISC, PATH, STATE) used for grouping/filtering" }, { "column": "table_type_reasoning", "role": "attribute", "confidence": 1.0, "reason": "Free-form explanatory text describing classification reasoning, high cardinality (421 distinct), for display only" }, { "column": "primary_key", "role": "attribute", "confidence": 0.9, "reason": "Descriptive field storing primary key column name(s) from classified table, medium cardinality (125 distinct), displayed 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 assessment, very sparse (96.5% null), for display only" }, { "column": "model_name", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (3 values including empty string) identifying the model used, for grouping/filtering" }, { "column": "latency_ms", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (milliseconds) to be aggregated with avg/sum/min/max for performance analysis" }, { "column": "token_usage_json", "role": "attribute", "confidence": 0.95, "reason": "JSON string containing structured metadata (cost, input/output tokens), high cardinality (257 distinct), primarily for display/reference" }, { "column": "created_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for temporal filtering, grouping by time periods, and ordering; unique per row but serves as temporal dimension" } ] } ```