conn_setting: Get or set DuckDB settings

In quak: Query 'Azure Data Lake Storage Gen2' with 'DuckDB'

Get or set DuckDB settings

Description

When called with no arguments, returns all settings as a data frame. When name is supplied and value is NULL, returns the value of that setting. When both name and value are supplied, executes ⁠SET <name> = <value>⁠.

Usage

conn_setting(conn = conn_default(), name = NULL, value = NULL)

Arguments

conn	A DuckDB connection.
name	Optional character scalar. Setting name.
value	Optional value to set. Coerced to character; DuckDB casts it to the appropriate type.

Value

All settings: a tibble::tibble(). Single setting read: a character scalar. Write: conn invisibly.

Examples

conn <- DBI::dbConnect(duckdb::duckdb())
conn_setting(conn, "threads")
DBI::dbDisconnect(conn, shutdown = TRUE)

quak documentation built on June 9, 2026, 5:09 p.m.