read_csv can take a list of files and combine them automatically, see: https://duckdb.org/docs/current/data/multiple_files/overview#list-of-globs Also consider https://github.com/nickzoic/duckdb-compression/ and https://github.com/duckdb/duckdb-python/issues/477
read_csv can take a list of files and combine them automatically, see: https://duckdb.org/docs/current/data/multiple_files/overview#list-of-globs
Also consider https://github.com/nickzoic/duckdb-compression/ and duckdb/duckdb-python#477