```json { "table_name": "samples", "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, uniqueness=1.000, and monotonicity=1.000. It uniquely identifies each sample row. For 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 internal sorting. No clustering key is needed.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table storing sample data rows from various source tables (indicated by tables_catalog_id). The id column is the primary identifier. The table acts as a catalog of data samples, with each row representing a unique sample. The row_json column contains the actual sample data payload. Metadata columns (_ingestion_timestamp, _batch_id, _source_file, _source_system) are all constant, indicating this is a single-batch snapshot." } ] } ```