```json { "table_name": "table_topology", "primary_key": "jobs_id,tables_catalog_id", "candidates": [ { "rank": 0, "partition_key": "jobs_id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV=2.88 indicates each job has ~3 table topology records on average. Top 3 coverage is 14.37%, well distributed. Semantically, jobs_id groups topology metadata by analysis job, which is the natural organizational unit for this metadata table.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require internal sorting. The composite primary key (jobs_id, tables_catalog_id) already ensures uniqueness.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a metadata dimension table describing table topology characteristics per job and table. The composite key (jobs_id, tables_catalog_id) uniquely identifies each row. Partitioning by jobs_id groups all topology records for a given analysis job together, enabling efficient job-level queries." } ] } ```