[R] duckdb table from multiple csv files

[Dr Eberhard Lisse]

Have a look at

	https://github.com/jqnatividad/qsv

and its cat command, which accepts wildcards. It can write to sqlite3
(so you can get it into duckdb), but also has an sqlp command.

el


On 2026/05/24 15:35, Naresh Gurbuxani wrote:
> 
> I have approximately ten thousand csv files with identical columns 
> and formats.  I want to run some SQL queries on a virtual database, 
> where all of these files are treated as one table.
[...]