Data Import
JSON Format Settings
With `format = 'newline_delimited'` newline-delimited JSON can be parsed.
Each line is a JSON.  
We use the example file [`records.json`](https://duckdb.org/data/records.json) with the following content:  
```json
{"key1":"value1", "key2": "value1"}
{"key1":"value2", "key2": "value2"}
{"key1":"value3", "key2": "value3"}
```  
```sql
SELECT *
FROM read_json('records.json', format = 'newline_delimited');
```  
<div class="narrow_table monospace_table"></div>  
|  key1  |  key2  |
|--------|--------|
| value1 | value1 |
| value2 | value2 |
| value3 | value3 |