Use JSON operators

sql

SELECT payload -> '$.type' AS raw_json,
       payload ->> '$.type' AS text_value
FROM events;

Explanation

`->` returns JSON text while `->>` returns a scalar SQL value when appropriate.

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

Check whether a string contains valid JSON.

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