Post #2312793
2026-05-09 16:09 UTC
@defuneste@fosstodon.org @LeafyEricScott@hachyderm.io *EDIT* sorry I missed that someone already suggested this!
I know “regular” DuckDB has the “Union by name” argument in read_csv() which might work, I’m not sure the R package version of read_csv() lets you use this, but presumably you could use the SQL syntax within dbGetQuery() and that might work? 🤔
https://duckdb.org/docs/current/data/multiple_files/combining_schemas
Replies (1)
-
@LeafyEricScott@hachyderm.io 2026-05-11 16:34
@cd_newton@hachyderm.io @defuneste@fosstodon.org duckdb::duckdb_read_csv() (the R fucnction) does *not* have the `union_by_name` argument 😭