{
    "table_name": "Indian Startups _ Funding  Investors Data March 2022",
    "primary_key": "Company Name",
    "candidates": [
        {
            "rank": 0,
            "partition_key": "Company Name",
            "partition_key_label": "primary_identifier",
            "partition_key_reasoning": "Company Name has 98 unique values across 98 rows (uniqueness 1.0, RPUV 1.00, 0% nulls). It is the entity this dimension table describes, so it works as the primary identifier. Because the table is small, partitioning on it is optional.",
            "clustering_key": null,
            "clustering_key_label": null,
            "clustering_key_reasoning": "Dimension tables need no internal sorting. The only other candidates are low-cardinality attributes such as Location, Stage and Founded, which describe the company and do not order it.",
            "world_line": null,
            "session_column": null,
            "confidence": "HIGH",
            "notes": "Each row is one startup with its attributes (location, sector, description, founders, investor, amount, stage). Company Name is unique in this monthly snapshot, which makes it the primary key. Other columns are not suitable as keys: What it does is unique but is long text, Founders is 99% unique and is a list of names, and Investor is a multi-value text field. The _ingestion_timestamp, _batch_id, _source_file and _source_system columns are constant metadata. The classification of this table as a dimension was accepted as given."
        }
    ]
}