```json { "classifications": [ { "column": "tenant_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key referencing tenant; used for JOINs and multi-tenancy filtering" }, { "column": "dataset_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values (109 distinct in 109 rows) and 'd_' prefix pattern" }, { "column": "name", "role": "attribute", "confidence": 0.85, "reason": "Descriptive dataset name for display; free-form text with some duplicates" }, { "column": "source", "role": "dimension", "confidence": 0.95, "reason": "Low-cardinality categorical field (5 values) for grouping/filtering by data source" }, { "column": "origin_url", "role": "attribute", "confidence": 0.9, "reason": "Descriptive URL path for display; high cardinality and free-form structure" }, { "column": "origin_slug", "role": "attribute", "confidence": 0.85, "reason": "Descriptive slug identifier for display; similar to name field" }, { "column": "created_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp for temporal grouping, filtering, and time-series analysis" }, { "column": "updated_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp for temporal grouping, filtering, and tracking modifications" }, { "column": "status", "role": "dimension", "confidence": 1.0, "reason": "Low-cardinality categorical field (3 values: deleted, ingesting, ready) for grouping/filtering" }, { "column": "current_batch_id", "role": "identifier", "confidence": 0.9, "reason": "Foreign key referencing batch; used for JOINs despite some nulls" }, { "column": "dataset_dir", "role": "attribute", "confidence": 0.95, "reason": "File system path for display; descriptive technical detail not used for grouping" }, { "column": "tags_json", "role": "attribute", "confidence": 0.8, "reason": "JSON field for metadata display; currently all null but intended for descriptive content" } ] } ```