Skip to main content

json_string

Description​

Converting JSON object to JSON string

Syntax​

json_string(json_object_expr)

Parameters​

  • json_object_expr: the expression that represents the JSON object. The object can be a JSON column, or a JSON object that is produced by a JSON constructor function such as PARSE_JSON.

Return value​

Returns a VARCHAR value.

Examples​

Example 1: Converting the JSON object to a JSON string

select json_string('{"Name": "Alice"}');
+----------------------------------+
| json_string('{"Name": "Alice"}') |
+----------------------------------+
| {"Name": "Alice"}                |
+----------------------------------+

Example 1: Convert the result of PARSE_JSON to a JSON string

select json_string(parse_json('{"Name": "Alice"}'));
+----------------------------------+
| json_string('{"Name": "Alice"}') |
+----------------------------------+
| {"Name": "Alice"}                |
+----------------------------------+