```json { "classifications": [ { "column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique sequential values" }, { "column": "tables_catalog_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing tables catalog" }, { "column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key with coded format (d_*) identifying datasets" }, { "column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key with coded format (batch_*) identifying batches" }, { "column": "method", "role": "dimension", "confidence": 1.0, "reason": "Categorical field with single value 'least_squares', used for grouping/filtering" }, { "column": "max_degree", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality numeric code (single value: 4) representing configuration parameter" }, { "column": "column_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (2-55) that would be aggregated with sum/avg" }, { "column": "pair_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (1-120) that would be aggregated with sum/avg" }, { "column": "sample_row_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity (16-5000) that would be aggregated with sum/avg" }, { "column": "columns_json", "role": "attribute", "confidence": 1.0, "reason": "JSON text content for display, not for grouping or aggregation" }, { "column": "pairs_json", "role": "attribute", "confidence": 1.0, "reason": "Large JSON text content for display, not for grouping or aggregation" }, { "column": "computed_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp used for filtering and grouping by time periods" } ] } ```