JSON_STRING

Learn how to use the JSON_STRING json function in PlaidCloud Lakehouse. Converts a JSON value to a JSON-encoded string - see syntax, examples, and output.

Converts a JSON value to a JSON-encoded string.

Analyze Syntax

func.json_string(get_column(table, 'data'))

Analyze Examples

func.json_string(get_column(table, 'json_val'))

┌───────────┐
│ '{"a":1}' │
└───────────┘

SQL Syntax

JSON_STRING(<data>)

SQL Examples

SELECT JSON_STRING(PARSE_JSON('{"a": 1}'));

┌─────────┐
│ {"a":1} │
└─────────┘