```json { "table_name": "quality_scorecards", "primary_key": "id", "candidates": [ { "rank": 0, "partition_key": "id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV = 1.00 (perfect uniqueness), 116 unique values across 116 rows, 0% null. Semantic role: unique identifier for each quality scorecard record. Classified as entity_column by the table classifier.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require internal sorting. No temporal or sequential ordering needed.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table storing quality scorecard metadata. The id column is the natural primary identifier. Alternative partitioning by dataset_id (RPUV=1.55, 75 unique values) could group scorecards by dataset, but id is the canonical key for this dimension table." } ] } ```