{
    "table_name": "Indian Startups _ Funding  Investors Data January 2022",
    "primary_key": "Company Name",
    "candidates": [
        {
            "rank": 0,
            "partition_key": "Company Name",
            "partition_key_label": "primary_identifier",
            "partition_key_reasoning": "Company Name has 114 unique values across 115 rows (RPUV 1.01, uniqueness 0.991, 0% nulls). It is the natural identifier of each startup. Top-3 coverage is only 3.48%.",
            "clustering_key": null,
            "clustering_key_label": null,
            "clustering_key_reasoning": "Dimension tables need no internal sorting. The only temporal column, _ingestion_timestamp, is a constant ingestion artifact and carries no ordering information.",
            "world_line": null,
            "session_column": null,
            "confidence": "MEDIUM",
            "notes": "Company Name is nearly unique. NowPurchase appears twice, with different Sector and Founders text, so it is not strictly unique. If a strict primary key is needed, a composite such as Company Name plus Sector or What it does would be required. Because it is a small table of 115 rows, a null partition key would also be acceptable. Founders is fully unique (115) but is a long multi-name text field, so it is a poor key. Columns such as Location, Stage and Founded are low-cardinality attributes and are not identifiers."
        }
    ]
}