Extract a JSON field

sql

SELECT json_extract(payload, '$.type') AS event_type FROM events;

Explanation

A core pattern for event logs and flexible payload 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 a JSON path with operator syntax.

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