Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
map_entries
functionApplies to: Databricks SQL Databricks Runtime
Returns an unordered array of all entries in map
.
map_entries(map)
map
: A MAP expression.An ARRAY of STRUCTs holding key-value pairs.
> SELECT map_entries(map(1, 'a', 2, 'b'));
[{1, a}, {2, b}]
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today