Re: duckdb table from multiple csv files

Eberhard W Lisse <[email protected]> Tue, 26 May 2026 16:49:34 +0200
Newsgroups gmane.comp.lang.r.general
Message-ID <[email protected]>
It can also write to parquet.

el

On 2026-05-26 15:25, Dr Eberhard Lisse wrote:
> 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.
> [...]
>