A SQL type for storing key-value pairs. Only maps with STRING keys can be turned into VARIANT through to_variant_object.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains MAP in context, with comparison tables and the common traps.
Terms in this definition
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- MAPS
Short for Microsoft Active Protection Service. It gives Microsoft Defender Antivirus cloud verdicts on suspect files in seconds, and features like file indicators stop working if it is turned off or blocked.
- STRING
The SQL type that holds text.
- KEYS
Lists the column or columns that identify each target row uniquely in an AUTO CDC statement.
- VARIANT
A type for semi-structured data like JSON whose structure isn't fixed, available from Databricks Runtime 15.4. It is preferred to storing JSON as strings but can't serve as a partition column.
Related terms
- ASIM parsers
Short for Advanced Security Information Model parsers: KQL functions that map Microsoft Sentinel data onto shared schemas when queried. That happens after ingestion has been charged, so ingestion costs are unaffected.
- Azure Maps visual
The map visual based on Azure Maps, offering layers such as bubbles, heat maps, 3D columns, filled areas, markers, paths and reference shapes. It has to be switched on by an admin in tenant settings and takes over from the Bing map and filled map, both due for deprecation.
- CSS
Language for styling web pages. Test Impact Analysis can't map edits like CSS or HTML to tests, so it runs everything.
- Data risk graph
Shows a map of a user's activity and files linked to an insider risk alert across the last 30 days, built on Microsoft Sentinel. Microsoft is retiring it on 24 November 2026.
- Dependency agent
Retiring 30 June 2028 together with the Map feature it supplies in VM insights; both are already deprecated.
- DNAT
Destination NAT. Inbound packets get a new target address, letting an outside IP map to a workload inside. On NSX this requires an active-standby gateway.
- Enterprise exposure graph
Exposure Management's map of assets, identities, findings and how they connect, fed by Entra ID, Defender for Cloud, Defender for Endpoint, Defender for Identity and connectors. Attack paths are built from it, and advanced hunting can query it.
- Error analysis
A Responsible AI dashboard tool. Using a decision tree and a heat map, it pinpoints cohorts that err more often than the model does overall.