Validate JSON text

sql

SELECT json_valid(payload) FROM events;

Explanation

Useful before imports, migrations, or backfilling generated columns.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Read JSON values

Read one property from a JSON document.

Open In sheetsqlsame section

Read a JSON path with operator syntax.

Open In sheetsqlsame section

See whether a value is text, array, object, number, and so on.

Open In sheetsqlsame section

Patch a document with json_set().

Open In sheetsql1 tag match

Delete one path from a document.

Open In sheetsql1 tag match

Turn array elements into result rows.

Open In sheetsql1 tag match