backend-duckdb {duckdb} | R Documentation |
This is a SQL backend for dbplyr tailored to take into account DuckDB's possibilities. This mainly follows the backend for PostgreSQL, but contains more mapped functions.
simulate_duckdb(...)
translate_duckdb(...)
... |
Any parameters to be forwarded |
library(dplyr, warn.conflicts = FALSE)
con <- DBI::dbConnect(duckdb(), path = ":memory:")
dbiris <- copy_to(con, iris, overwrite = TRUE)
dbiris %>%
select(Petal.Length, Petal.Width) %>%
filter(Petal.Length > 1.5) %>%
head(5)
DBI::dbDisconnect(con, shutdown = TRUE)