```json { "classifications": [ { "column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values (1078 distinct in 1078 rows)" }, { "column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing datasets, used for JOINs" }, { "column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing batches, used for JOINs" }, { "column": "module", "role": "dimension", "confidence": 1.0, "reason": "Categorical field with 11 distinct values (analytics, bronze, catalog, etc.), used for grouping/filtering" }, { "column": "outcome", "role": "dimension", "confidence": 1.0, "reason": "Categorical status field with 2 values (failed, success), used for grouping/filtering" }, { "column": "reason", "role": "attribute", "confidence": 1.0, "reason": "Free-form descriptive text explaining failures, displayed but not aggregated (98% null)" }, { "column": "produced_json", "role": "attribute", "confidence": 0.95, "reason": "JSON content field for display, nearly always null (99.9%), not grouped or aggregated" }, { "column": "attempt", "role": "measure", "confidence": 0.9, "reason": "Numeric counter (1-5) that can be aggregated (avg/max attempts per stage)" }, { "column": "started_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp used for filtering, grouping by time periods, and temporal analysis" }, { "column": "finished_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp used for filtering, grouping by time periods, and temporal analysis" } ] } ```