read_sql_duckdb {duckplyr} | R Documentation |
Return SQL query as duckdb_tibble
Description
Runs a query and returns it as a duckplyr frame.
Usage
read_sql_duckdb(
sql,
...,
prudence = c("thrifty", "lavish", "stingy"),
con = NULL
)
Arguments
sql |
The SQL to run. |
... |
These dots are for future extensions and must be empty. |
prudence |
Memory protection, controls if DuckDB may convert intermediate results in DuckDB-managed memory to data frames in R memory.
The default is |
con |
The connection, defaults to the default connection. |
Details
Using data frames from the calling environment is not supported yet, see https://github.com/duckdb/duckdb-r/issues/645 for details.
See Also
Examples
read_sql_duckdb("FROM duckdb_settings()")
[Package duckplyr version 1.1.0 Index]