Why has the format of object value in my Sigma query result changed?
As of 3 September 2020, Sigma has supported queries using Prestosql v334 SQL syntax. As a part of this change, object values (such as map, array etc.) are now encoded in JSON format.
For example:
SELECT id, map_agg(key, value) AS dictionary FROM charges_metadata GROUP BY id
Old behaviour:
id, dictionary
ch_123,{a=123, b=hello world}
...
New behaviour:
id, dictionary
ch_123,"{""a"":""123"",""b"":""hello world""}"
Did this answer your question?
Related articles