```json { "table_name": "tag_lineage_edges", "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, monotonicity = 1.000. This is the primary identifier for tag lineage edges. While RPUV=1 typically indicates one file per row, for dimension tables the primary_identifier serves as the natural partition key for lookups and joins.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables do not require internal sorting. No clustering key needed.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table tracking metadata about tag lineage edges (relationships between consumers, datasets, tables, columns, and their semantic tags). The id column is the unique identifier. The table has temporal tracking columns (first_seen_at, last_seen_at) but these are event-time attributes of each edge, not a time axis for partitioning. The table is small enough (42K rows) that partitioning by id is appropriate for dimension lookup patterns." } ] } ```