Skip to main content

Extract Values from a Map

A MAP type column contains a delimited list of key:value pairs. Map columns are imported into AtScale as STRING type columns. Although AtScale does not support the MAP data type, you can create calculated columns from strings containing maps. This generates a calculated column formula using the REGEXP_EXTRACT function.

To creata a calculated column from a map, you must edit the dataset's underlying SML to include the map property. For more information, see the AtScale SML Object Documentation on GitHub.