duckdb_register()
registers a data frame as a virtual table (view)
in a DuckDB connection.
No data is copied.
Usage
duckdb_register(conn, name, df, overwrite = FALSE, experimental = FALSE)
duckdb_unregister(conn, name)
Arguments
- conn
A DuckDB connection, created by
dbConnect()
.- name
The name for the virtual table that is registered or unregistered
- df
A
data.frame
with the data for the virtual table- overwrite
Should an existing registration be overwritten?
- experimental
Enable experimental optimizations
Examples
con <- dbConnect(duckdb())
data <- data.frame(a = 1:3, b = letters[1:3])
duckdb_register(con, "data", data)
dbReadTable(con, "data")
#> a b
#> 1 1 a
#> 2 2 b
#> 3 3 c
duckdb_unregister(con, "data")
dbDisconnect(con)