duckdb_register() registers a data frame as a virtual table (view) in a DuckDB connection. No data is copied.
duckdb_register()
duckdb_register(conn, name, df, overwrite = FALSE, experimental = FALSE)duckdb_unregister(conn, name)
duckdb_unregister(conn, name)
These functions are called for their side effect.
A DuckDB connection, created by dbConnect().
dbConnect()
The name for the virtual table that is registered or unregistered
A data.frame with the data for the virtual table
data.frame
Should an existing registration be overwritten?
Enable experimental optimizations
duckdb_unregister() unregisters a previously registered data frame.
duckdb_unregister()
con <- dbConnect(duckdb()) data <- data.frame(a = 1:3, b = letters[1:3]) duckdb_register(con, "data", data) dbReadTable(con, "data") duckdb_unregister(con, "data") dbDisconnect(con)
Run the code above in your browser using DataLab