Package index • duckdb

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>,<character>) 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

simulate_duckdb() translate_duckdb() tbl_file() tbl_query(): 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_get_substrait(): Get the Substrait plan for a SQL query Transforms a SQL query into a raw vector containing the serialized Substrait query blob

duckdb_get_substrait_json(): Get the Substrait plan for a SQL query in the JSON format Transforms a SQL query into a vector containing the serialized Substrait query JSON

duckdb_prepare_substrait(): Query DuckDB using Substrait Method for interpreting a Substrait BLOB plan as a DuckDB Query Plan It interprets and executes the query.

duckdb_prepare_substrait_json(): Query DuckDB using Substrait Method for interpreting a Substrait JSON plan as a DuckDB Query Plan It interprets and executes the query.

duckdb_explain-class duckdb_explain print.duckdb_explain: DuckDB EXPLAIN query tree