Reading Multiple Files

DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different schemas. CSV -- read all files with a name ending in ".csv" in the folder "dir" SELECT * FROM 'dir/*.csv'; -- read all files with a name ending in ".csv", two directories deep SELECT * FROM '*/*/*.csv'; -- read all files with a name ending in ".csv", at any depth in the folder "dir" SELECT * FROM 'dir/**/*.csv';…