```json { "classifications": [ {"column": "metric_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique VARCHAR values (m_5ef7a17b pattern)"}, {"column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing dataset table (d_aea44c0f pattern)"}, {"column": "name", "role": "attribute", "confidence": 0.95, "reason": "Descriptive metric name displayed but not aggregated"}, {"column": "sql_text", "role": "attribute", "confidence": 1.0, "reason": "Long-form SQL query text for display only"}, {"column": "sql_fingerprint", "role": "identifier", "confidence": 0.95, "reason": "Hash/fingerprint used to identify unique SQL queries"}, {"column": "origin", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping/filtering (authored, proposed)"}, {"column": "template_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key or code referencing template (FLAG_RATE)"}, {"column": "segment_column", "role": "attribute", "confidence": 0.9, "reason": "Descriptive metadata about segmentation column"}, {"column": "result_types", "role": "attribute", "confidence": 1.0, "reason": "JSON metadata describing result schema, for display"}, {"column": "has_period", "role": "dimension", "confidence": 0.95, "reason": "Boolean flag (0/1) for grouping/filtering"}, {"column": "direction", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for filtering (up_is_good, down_is_good)"}, {"column": "target_value", "role": "attribute", "confidence": 0.85, "reason": "Descriptive target value (currently all null)"}, {"column": "target_kind", "role": "dimension", "confidence": 0.95, "reason": "Categorical type field for grouping (none)"}, {"column": "material_delta", "role": "measure", "confidence": 1.0, "reason": "Numeric threshold value that could be aggregated"}, {"column": "support_floor", "role": "measure", "confidence": 0.95, "reason": "Numeric threshold/minimum value (50)"}, {"column": "declared_by", "role": "dimension", "confidence": 0.9, "reason": "Categorical field for grouping by user/process"}, {"column": "declared_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and time-based grouping"}, {"column": "status", "role": "dimension", "confidence": 1.0, "reason": "Categorical status field for filtering (active)"}, {"column": "broken_code", "role": "attribute", "confidence": 0.85, "reason": "Error/diagnostic code for display (currently all null)"} ] } ```