Write as JSON Map directive
The WRITE-AS-JSON-MAP directive converts the record into a JSON map.
Syntax
write-as-json-map :column
The column
will contain a JSON map of all the fields in the record.
Usage Notes
The WRITE-AS-JSON-MAP directive converts the entire record into a JSON map. If the column
already exists, it will overwrite it.
Depending on the type of object a field is holding, it will be transformed appropriately.
Example
Using this record as an example:
{
"int": 1,
"string": "this, is a string."
}
Applying this directive:
write-as-json-map :body
results in this record:
Created in 2020 by Google Inc.