Data Import
Multi-File Reads and Globs
DuckDB can also read a series of Parquet files and treat them as if they were a single table. Note that this only works if the Parquet files have the same schema. You can specify which Parquet files you want to read using a list parameter, glob pattern matching syntax, or a combination of both.  
#### List Parameter {#docs:data:multiple_files:overview::list-parameter}  
The `read_parquet` function can accept a list of filenames as the input parameter.  
Read three Parquet files and treat them as a single table:  
```sql
SELECT *
FROM read_parquet(['file1.parquet', 'file2.parquet', 'file3.parquet']);
```  
#### Glob Syntax {#docs:data:multiple_files:overview::glob-syntax}  
Any file name input to the `read_parquet` function can either be an exact filename, or use a glob syntax to read multiple files that match a pattern.  
<div class="narrow_table"></div>  
|  Wildcard  |                        Description                        |
|------------|-----------------------------------------------------------|
| `*`        | matches any number of any characters (including none)     |
| `**`       | matches any number of subdirectories (including none)     |
| `?`        | matches any single character                              |
| `[abc]`    | matches one character given in the bracket                |
| `[a-z]`    | matches one character from the range given in the bracket |  
Note that the `?` wildcard in globs is not supported for reads over S3 due to HTTP encoding issues.  
Here is an example that reads all the files that end with `.parquet` located in the `test` folder:  
Read all files that match the glob pattern:  
```sql
SELECT *
FROM read_parquet('test/*.parquet');
```  
#### List of Globs {#docs:data:multiple_files:overview::list-of-globs}  
The glob syntax and the list input parameter can be combined to scan files that meet one of multiple patterns.  
Read all Parquet files from 2 specific folders.  
```sql
SELECT *
FROM read_parquet(['folder1/*.parquet', 'folder2/*.parquet']);
```  
DuckDB can read multiple CSV files at the same time using either the glob syntax, or by providing a list of files to read.