```json { "table_name": "column_tag_overrides", "primary_key": "id", "candidates": [ { "rank": 0, "partition_key": "id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "id is the unique identifier with RPUV=1.00 and uniqueness=1.000, perfectly identifying each override record. However, with only 2 rows, partitioning provides no practical benefit.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require clustering. With only 2 rows, no internal sorting is needed.", "world_line": null, "session_column": null, "confidence": "MEDIUM", "notes": "This is a dimension table storing metadata about column tag overrides. The id column is the primary key. With only 2 rows, partitioning is not practically useful, but id is the semantic primary identifier. The table tracks manual overrides to column classifications (dataset_id, table_name, column_name, family, tag) with audit fields (changed_by, changed_at). All other columns have RPUV=1.00 or RPUV=2.00 (single value), making them unsuitable as partition keys." } ] } ```