```json { "table_name": "accounts", "primary_key": "account", "candidates": [ { "rank": 0, "partition_key": "account", "partition_key_label": "primary_identifier", "partition_key_reasoning": "RPUV = 1.00 (85 unique values for 85 rows), uniqueness = 1.000, confirming each account is unique. This is the natural primary identifier for the dimension table, representing distinct business accounts/companies.", "clustering_key": null, "clustering_key_label": null, "clustering_key_reasoning": "Dimension tables typically do not require internal sorting. All attributes are descriptive properties of each account entity.", "world_line": null, "session_column": null, "confidence": "HIGH", "notes": "Classic dimension table with account as the primary identifier. The table contains 85 distinct companies with their attributes (sector, year_established, revenue, employees, office_location, subsidiary_of). Metadata columns (_ingestion_timestamp, _batch_id, _source_file, _source_system) are technical artifacts with RPUV = 85.00, indicating single-batch ingestion. The subsidiary_of column creates a self-referential hierarchy (e.g., Acme Corporation has 4 subsidiaries)." } ] } ```