JSON Extract
Extract data in JSON format into columns
What It Does
JSON Extract parses JSON strings in a column and extracts values into new columns or rows. Handles both JSON objects (dictionaries) and arrays.
How to Use It
Opening the Panel
Click the + button in the toolbar or press the operation picker, then search for "JSON Extract". It's in the Data group.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
Column | Column select | Yes | The column containing JSON strings |
JSON type | Select | Yes | dictionary (object) or array |
Extract as | Select | Yes | columns (side by side) or rows (one per value) |
Keys | Key editor | For dictionaries | JSON keys to extract and their types |
SQL generated under the hood
SELECT *, metadata->>'name' AS name, metadata->>'age' AS age FROM dataRelated Operations
- Join - Join with another file/table
- Unnest - Explode delimited column into rows
- Fill Missing - Fill null values