JSON Scalar

json_valid()

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

json_valid(json)

Scalar
Overload link json Returns
#01 JSON BOOLEAN
#02 VARCHAR BOOLEAN

In other engines

Used in larger rewrites 1

These examples use json_valid as one part of a larger SQL translation.

Snowflaketry_parse_json()

SELECT TRY_PARSE_JSON(x)
In DuckDB
SELECT CASE WHEN JSON_VALID(x) THEN CAST(x AS JSON) ELSE NULL END

SQLGlot example โ†—