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'; Read the CSV…