Package index • duckdb

Getting started

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

Driver

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

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>) dbSendQuery(<duckdb_connection>,<character>) dbWriteTable(<duckdb_connection>,<character>,<data.frame>) show(<duckdb_connection>): DuckDB connection class

Result

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

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