Is it possible to retrieve the whole string from a column with data type Map?

Matillion ETL
1

I'm trying to retrieve the whole string from a column with data type Map but it pulls empty. However I can get the values individually like the below image:

 

0694G00000QdURfQAN_0D54G000098ICgaSAG
0694G00000QdURfQAN_0D54G000098ICgaSAG833×115 4.39 KB

Here is the query:

SELECT ,map

,“map.mapid” 

     ,“map.data”

     ,“map.areaid”

     ,“map.cmd”

FROM {Table}

WHERE “column01” = ‘12345’

and “column02”= 12345

 

Here is the whole string from the map columns:

{ “mapid” : { “N” : “55010” }, “areaid” : { “N” : “79189” }, “cmd” : { “S” : “areaClean” } }

 

Note: I’m working on Matillion for Redshift

 

Thanks.