```json { "classifications": [ { "column": "Company", "role": "identifier", "confidence": 0.95, "reason": "Company name serves as primary key to identify each unique funding deal; high distinct count (161/171) indicates uniqueness" }, { "column": "Amount", "role": "measure", "confidence": 0.9, "reason": "Funding amount is a numeric quantity to be aggregated (sum/avg); stored as VARCHAR but represents monetary value" }, { "column": "Lead investors", "role": "attribute", "confidence": 0.85, "reason": "Descriptive text listing investor names; high cardinality (134/171) and free-form nature make it display-only content" }, { "column": "Valuation", "role": "measure", "confidence": 0.9, "reason": "Company valuation is a numeric quantity to aggregate; stored as VARCHAR but represents monetary value" }, { "column": "Industry", "role": "dimension", "confidence": 0.95, "reason": "Categorical field with medium cardinality (63 values) used to group, slice, and filter deals by sector" }, { "column": "Date reported", "role": "dimension", "confidence": 0.95, "reason": "Temporal field used to group by time periods, filter date ranges, and analyze trends over time" } ] } ```