Package index • duckdb

Getting started

One-line entry points for running a query or grabbing a throwaway in-memory connection.

sql_query() sql_exec() experimental: Run an SQL query or statement
default_conn() experimental: Get the default connection

Driver

Create or reuse a DuckDB database instance and the driver object passed to dbConnect().

duckdb() duckdb_shutdown() duckdb_adbc() dbConnect(<duckdb_driver>) dbDisconnect(<duckdb_connection>): Connect to a DuckDB database instance
dbDataType(<duckdb_driver>) dbGetInfo(<duckdb_driver>) dbIsValid(<duckdb_driver>) show(<duckdb_driver>): DuckDB driver class

Connection

The DBI connection to a DuckDB database and its methods.

dbAppendTable(<duckdb_connection>) dbBegin(<duckdb_connection>) dbCommit(<duckdb_connection>) dbDataType(<duckdb_connection>) dbExistsTable(<duckdb_connection>,<ANY>) dbGetInfo(<duckdb_connection>) dbIsValid(<duckdb_connection>) dbListFields(<duckdb_connection>,<character>) dbListTables(<duckdb_connection>) dbQuoteIdentifier(<duckdb_connection>,<ANY>) dbQuoteLiteral(<duckdb_connection>) dbRemoveTable(<duckdb_connection>,<character>) dbRollback(<duckdb_connection>) dbSendQueryArrow(<duckdb_connection>,<character>) dbSendQuery(<duckdb_connection>,<character>) dbWriteTable(<duckdb_connection>,<character>,<data.frame>) show(<duckdb_connection>): DuckDB connection class

Result

The object returned by a query, used to fetch rows and column metadata.

duckdb_fetch_arrow() duckdb_fetch_record_batch() dbBind(<duckdb_result>) dbClearResult(<duckdb_result>) dbColumnInfo(<duckdb_result>) dbFetch(<duckdb_result>) dbGetInfo(<duckdb_result>) dbGetRowCount(<duckdb_result>) dbGetRowsAffected(<duckdb_result>) dbGetStatement(<duckdb_result>) dbHasCompleted(<duckdb_result>) dbIsValid(<duckdb_result>) show(<duckdb_result>): DuckDB Result Set

Interfaces

Integrations with other parts of the R ecosystem: the dplyr/dbplyr backend, registering data frames and Arrow data as tables, reading CSV files, and inspecting query plans.

tbl_file() tbl_function() tbl_query() simulate_duckdb(): DuckDB SQL backend for dbplyr
duckdb_register() duckdb_unregister(): Register a data frame as a virtual table
duckdb_register_arrow() duckdb_unregister_arrow() duckdb_list_arrow(): Register an Arrow data source as a virtual table
duckdb_read_csv(): Reads a CSV file into DuckDB
duckdb_explain-class duckdb_explain print.duckdb_explain: DuckDB EXPLAIN query tree

Storage locations

Where DuckDB writes extensions, stored secrets, and temporary files, and how to choose those locations so that nothing is written outside the session’s temporary directory unless you opt in.

duckdb_storage experimental: DuckDB file-system usage: storage locations and how they are resolved
duckdb_extension_storage() duckdb_secret_storage() duckdb_storage_status() experimental: Configure where DuckDB stores extensions and secrets