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.