```json { "table_name": "neal_probe_runs", "primary_key": "id", "candidates": [ { "rank": 0, "partition_key": "id", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV = 1.00 (perfectly unique), uniqueness = 1.000, top-3 coverage = 0.44%. This is the primary identifier for probe run records. As a dimension table, the primary identifier serves as the natural partition key.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require clustering. Each probe run is an independent entity without internal ordering requirements.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table cataloging probe run metadata. The id column is the unique identifier for each probe run. The table contains reference data about data quality probe executions (concentration, relationship, duplication, etc.) with their status, timing, and results. Three timestamp columns (created_at, started_at, finished_at) track the probe lifecycle but are event markers rather than a temporal axis for partitioning. The _ingestion_timestamp, _batch_id, _source_file, and _source_system columns are ETL metadata (all single-valued in this snapshot)." } ] } ```