```json { "classifications": [ {"column": "id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique BIGINT values per row"}, {"column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing dataset, used for joins"}, {"column": "batch_id", "role": "identifier", "confidence": 1.0, "reason": "Foreign key referencing batch, used for joins"}, {"column": "table_name", "role": "dimension", "confidence": 0.95, "reason": "High cardinality (18203) but used to identify/filter tables, not a join key"}, {"column": "iceberg_namespace", "role": "dimension", "confidence": 1.0, "reason": "Low cardinality (2 values: api, gold), categorical grouping dimension"}, {"column": "iceberg_snapshot_id", "role": "identifier", "confidence": 1.0, "reason": "Snapshot identifier for versioning, used as a key"}, {"column": "committed_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and time-based grouping"}, {"column": "source_format", "role": "dimension", "confidence": 1.0, "reason": "Low cardinality (3 values: csv, parquet, table), categorical dimension"}, {"column": "source_path", "role": "attribute", "confidence": 1.0, "reason": "File path, descriptive content for display, not grouped"}, {"column": "row_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate (sum/avg row counts)"}, {"column": "byte_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate (sum/avg byte sizes)"}, {"column": "column_count", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate (sum/avg column counts)"}, {"column": "null_count_total", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate (sum/avg null counts)"}, {"column": "schema_json", "role": "attribute", "confidence": 1.0, "reason": "JSON text, descriptive schema definition for display"}, {"column": "query", "role": "attribute", "confidence": 1.0, "reason": "SQL query text, descriptive content for display"}, {"column": "description", "role": "attribute", "confidence": 1.0, "reason": "Free-form text description for display"}, {"column": "ingest_started_at", "role": "dimension", "confidence": 1.0, "reason": "Timestamp for filtering and time-based grouping"}, {"column": "ingest_elapsed_ms", "role": "measure", "confidence": 1.0, "reason": "Numeric duration to aggregate (avg/sum elapsed time)"} ] } ```