```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 for display (e.g., 'delivery completion rate')"}, {"column": "sql_text", "role": "attribute", "confidence": 1.0, "reason": "Long-form SQL query text for display, not for grouping or aggregation"}, {"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 vs 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 text specifying column name, not for grouping"}, {"column": "result_types", "role": "attribute", "confidence": 0.95, "reason": "JSON schema definition for display, not for grouping or aggregation"}, {"column": "has_period", "role": "dimension", "confidence": 0.9, "reason": "Boolean flag (0/1) for filtering/grouping metrics with time periods"}, {"column": "direction", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping (up_is_good vs down_is_good)"}, {"column": "target_value", "role": "attribute", "confidence": 0.85, "reason": "Descriptive target value (currently null), not aggregated"}, {"column": "target_kind", "role": "dimension", "confidence": 0.95, "reason": "Categorical field for grouping target types"}, {"column": "material_delta", "role": "measure", "confidence": 1.0, "reason": "Numeric threshold value that could be averaged or compared"}, {"column": "support_floor", "role": "measure", "confidence": 0.95, "reason": "Numeric threshold value (50) that could be aggregated"}, {"column": "declared_by", "role": "attribute", "confidence": 0.95, "reason": "Descriptive text identifying who declared the metric"}, {"column": "declared_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp for filtering and time-based grouping"}, {"column": "status", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for filtering/grouping (active status)"}, {"column": "broken_code", "role": "attribute", "confidence": 0.9, "reason": "Descriptive error code (currently null), for display not grouping"} ] } ```