Skip to contents

Connections and Azure credentials

az_conn()
Open a DuckDB connection configured for Azure Data Lake Storage Gen2
az_conn_settings()
Get Azure settings from a DuckDB connection
az_default_scope()
Get the default Azure OAuth scope
az_list_secrets()
List Azure secrets registered in DuckDB
az_set_chain_secret()
Register an Azure credential-chain secret
az_set_sp_secret()
Register an Azure service-principal secret
az_set_token_secret()
Register an Azure token secret
az_tune()
Tune Azure read settings on a DuckDB connection
conn_setting()
Get or set DuckDB settings

Lazy tables and registered datasets

tbl_delta()
Open a Delta Lake table as a lazy dplyr tbl
tbl_parquet()
Open a Parquet dataset as a lazy dplyr tbl
tbl_csv()
Open a CSV dataset as a lazy dplyr tbl
tbl_json()
Open a JSON dataset as a lazy dplyr tbl
collect(<tbl_az>)
Collect an Azure-backed lazy tbl
collect_arrow()
Collect an Azure-backed lazy tbl as Arrow data
stream_arrow()
Stream an Azure-backed lazy tbl as Arrow record batches
load_dataset()
Register a Delta, Parquet, CSV, or JSON dataset on a DuckDB connection
load_delta()
Register a Delta Lake table on a DuckDB connection
load_parquet()
Register a Parquet dataset as a view on a DuckDB connection
load_csv()
Register a CSV dataset as a view on a DuckDB connection
load_json()
Register a JSON dataset as a view on a DuckDB connection

Azure lake operations

az_copy_to()
Copy data to Azure Data Lake Storage Gen2
az_write_parquet()
Write Parquet data to Azure Data Lake Storage Gen2
az_glob()
List Azure paths matching a glob pattern
az_exists()
Check whether data exists at an Azure path
az_schema()
Inspect a dataset schema without collecting data
az_glimpse()
Preview an Azure dataset
az_delta_files()
List files in a Delta table on Azure Data Lake Storage Gen2

Extension repositories and cache

ext_cache()
Extension cache
ext_cache_path()
Default DuckDB extension cache directory
ext_dir()
Find the DuckDB extension folder
ext_install()
Install a DuckDB extension
ext_install_local()
Install a DuckDB extension from a local file
ext_is_installed()
Check whether a DuckDB extension is installed
ext_list_available()
List all DuckDB core extensions
ext_list_installed()
List installed DuckDB extensions
ext_load()
Load a DuckDB extension, installing it first if necessary
ext_set_dir()
Set the DuckDB extension folder
ext_uninstall()
Uninstall a DuckDB extension
repo_set_urls()
Set DuckDB extension repository URLs
repo_urls()
Get DuckDB extension repository URLs
quak_options()
List all quak options and their current values
print(<quak_opts>)
Print the quak option registry