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.
[...]
______________________________________________
[email protected] mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide https://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
