Source
How to Merge/Combine Two JSON Field Together with Large Number of Attributes
ISSUE: In scenarios where it is required to merge or combine two JSON (Variant) fields with large number of attributes together to get the desired result, usage of functions like OBJECT_CONSTRUCT are useful but cumbersome to implement.
How to parse special characters in PARSE_JSON function
ISSUE: The backslash (/) is a special character in JSON data, but sometimes it needs to be stored in JSON as part of a key or value.
TO_JSON
Converts a VARIANT value to a string containing the JSON representation of the value.
Usage of escape character in JSON data file.
In order to escape the quotes enclosing around the word Bengaluru, a backslash character \ needs to be added in front of quotes ( \"Bengaluru\" ) in the JSON data file before it can be uploaded to a stage.