motherduck (version 0.2.0)

config_db: DuckDB runtime database configuration (config_db)

Description

A named character list of DuckDB runtime configuration settings used by the package. This object includes allocator settings, thread counts, extension flags, storage and checkpoint options, security and secret settings, and other engine-level options. These settings reflect the values returned by config_db and are suitable as a template or reference for configuring DuckDB instances created via the package.

Usage

config_db

Format

A named character list. Example names and values include:

access_mode

character; e.g. "automatic"

allocator_background_threads

character; "true"/"false"

allocator_bulk_deallocation_flush_threshold

character; e.g. "512MB"

allocator_flush_threshold

character; e.g. "128MB"

allow_community_extensions

character; "true"/"false"

allow_extensions_metadata_mismatch

character; "true"/"false"

allow_persistent_secrets

character; "true"/"false"

allow_unredacted_secrets

character; "true"/"false"

allow_unsigned_extensions

character; "true"/"false"

arrow_large_buffer_size

character; "true"/"false"

arrow_lossless_conversion

character; "true"/"false"

arrow_output_list_view

character; "true"/"false"

autoinstall_extension_repository

character; URL or empty string

autoinstall_known_extensions

character; "true"/"false"

autoload_known_extensions

character; "true"/"false"

ca_cert_file

character; path to certificate file, or empty string

catalog_error_max_schemas

character; numeric as string, e.g. "100"

checkpoint_threshold

character; e.g. "16MB"

wal_autocheckpoint

character; e.g. "16MB"

custom_extension_repository

character; URL or empty string

custom_user_agent

character; string or empty

default_block_size

character; e.g. "262144"

default_collation

character; collation name or empty

default_null_order

character; e.g. "NULLS_LAST"

null_order

character; e.g. "NULLS_LAST"

default_order

character; e.g. "ASC"

default_secret_storage

character; e.g. "local_file"

disabled_compression_methods

character; list or empty

duckdb_api

character; e.g. "cli"

enable_external_access

character; "true"/"false"

enable_external_file_cache

character; "true"/"false"

enable_fsst_vectors

character; "true"/"false"

enable_http_metadata_cache

character; "true"/"false"

enable_macro_dependencies

character; "true"/"false"

enable_object_cache

character; "true"/"false"

enable_server_cert_verification

character; "true"/"false"

enable_view_dependencies

character; "true"/"false"

extension_directory

character; path or empty

external_threads

character; numeric as string, e.g. "1"

force_download

character; "true"/"false"

immediate_transaction_mode

character; "true"/"false"

index_scan_max_count

character; numeric as string, e.g. "2048"

index_scan_percentage

character; numeric as string, e.g. "0.001"

lock_configuration

character; "true"/"false"

max_vacuum_tasks

character; numeric as string, e.g. "100"

old_implicit_casting

character; "true"/"false"

parquet_metadata_cache

character; "true"/"false"

preserve_insertion_order

character; "true"/"false"

produce_arrow_string_view

character; "true"/"false"

scheduler_process_partial

character; "true"/"false"

secret_directory

character; path for persistent secrets

storage_compatibility_version

character; e.g. "v0.10.2"

temp_directory

character; path or empty string

threads

character; number of threads as string, e.g. "4"

worker_threads

character; number of threads as string, e.g. "4"

username

character; string or empty

user

character; string or empty

zstd_min_string_length

character; numeric as string, e.g. "4096"

Examples

# inspect the config
config_db
# access individual settings
config_db$threads