Data Import
The `read_json` Function
The `read_json` is the simplest method of loading JSON files: it automatically attempts to figure out the correct configuration of the JSON reader. It also automatically deduces types of columns.  
```sql
SELECT *
FROM read_json('todos.json')
LIMIT 5;
```  
| userId | id |                              title                              | completed |
|-------:|---:|-----------------------------------------------------------------|-----------|
| 1      | 1  | delectus aut autem                                              | false     |
| 1      | 2  | quis ut nam facilis et officia qui                              | false     |
| 1      | 3  | fugiat veniam minus                                             | false     |
| 1      | 4  | et porro tempora                                                | true      |
| 1      | 5  | laboriosam mollitia et enim quasi adipisci quia provident illum | false     |  
The path can either be a relative path (relative to the current working directory) or an absolute path.  
We can use `read_json` to create a persistent table as well:  
```sql
CREATE TABLE todos AS
SELECT *
FROM read_json('todos.json');
DESCRIBE todos;
```  
<div class="narrow_table monospace_table"></div>  
| column_name | column_type | null | key | default | extra |
|-------------|-------------|------|-----|---------|-------|
| userId      | UBIGINT     | YES  |     |         |       |
| id          | UBIGINT     | YES  |     |         |       |
| title       | VARCHAR     | YES  |     |         |       |
| completed   | BOOLEAN     | YES  |     |         |       |  
If we specify the columns, we can bypass the automatic detection. Note that not all columns need to be specified:  
```sql
SELECT *
FROM read_json('todos.json',
columns = {userId: 'UBIGINT',
completed: 'BOOLEAN'});
```  
Multiple files can be read at once by providing a glob or a list of files. Refer to the [multiple files section](#docs:data:multiple_files:overview) for more information.