```json { "table_name": "fifa_ranking_2026_06_08", "primary_key": "team", "candidates": [ { "rank": 0, "partition_key": "team", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV = 1.00, uniqueness = 1.000, each team appears exactly once. This is the natural primary identifier for a FIFA ranking snapshot dimension table.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables do not require internal sorting. Each row is a complete team record at a point in time.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "This is a dimension table representing a single FIFA ranking snapshot dated 2026-06-08. The table contains 211 teams with their rankings, points, and associations. The team column serves as the unique identifier. Alternative keys like team_code or rank are also unique but team is the semantic primary identifier. The _ingestion_timestamp, _batch_id, _source_file, and _source_system columns are all constant (RPUV=211), indicating this is a single-batch snapshot load." } ] } ```