```json { "table_name": "schema_migrations", "primary_key": "version", "candidates": [ { "rank": 0, "partition_key": "version", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV=1.00, uniqueness=1.000, perfect identifier for schema migration versions. Each version is unique and represents a distinct migration step.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require clustering. The table is small (47 rows) and already naturally ordered by version number.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "Classic dimension table tracking database schema migration history. Version is the natural primary key with perfect uniqueness. Applied_at provides temporal context but is not needed for partitioning in a dimension table. The table is small and static, making it ideal for broadcast joins in analytical queries." } ] } ```