Skip to contents

All functions

db_browser()
Browse the data lake interactively
db_browser_server()
Shiny module server for db_browser()
db_browser_ui()
Shiny module UI for db_browser()
db_catalog()
List tables and file stats tracked by DuckLake
db_connect()
Connect to the CSO hive parquet lake
db_create_schema()
Create a new schema in DuckLake
db_dataset_exists()
Check if a hive dataset exists
db_describe()
Describe a dataset or table
db_describe_column()
Describe a column
db_dictionary()
Generate a data dictionary
db_diff()
Compare a table between two snapshots
db_disconnect()
Disconnect from the CSO Data Lake
db_get_docs()
Get documentation for a dataset or table
db_get_partitioning()
Get partitioning configuration for a DuckLake table
db_hive_read()
Read a CSO Dataset from hive-partitioned parquet (lazy)
db_hive_write()
Publish / Append / Ignore / Replace Partitions in the Hive Lake
db_is_public()
Check if a dataset is in the public catalog (Hive mode only)
db_lake_connect()
Connect to DuckDB + attach a DuckLake catalog
db_lake_read()
Read a DuckLake table (lazy)
db_lake_write()
Write a DuckLake table (overwrite/append)
db_list_datasets()
List datasets within a section
db_list_public()
List all datasets in the public catalog (Hive mode only)
db_list_schemas()
List schemas in the DuckLake catalog
db_list_sections()
List sections in the hive data lake
db_list_views()
List views in a DuckLake schema
db_preview_hive_write()
Preview a hive write operation
db_preview_lake_write()
Preview a DuckLake write operation
db_preview_upsert()
Preview an upsert operation
db_query()
Run arbitrary SQL and return results
db_rollback()
Rollback a table to a previous snapshot
db_search()
Search for datasets or tables
db_search_columns()
Search for columns
db_set_partitioning()
Set partitioning for a DuckLake table
db_set_private()
Remove a dataset from the public catalog (Hive mode only)
db_set_public()
Make a dataset discoverable in the public catalog (Hive mode only)
db_snapshots()
List DuckLake snapshots
db_status()
Get connection status and configuration
db_sync_catalog()
Sync the public catalog with source metadata (Hive mode only)
db_table_cols()
Get column names for a DuckLake table
db_table_exists()
Check if a DuckLake table exists
db_tables()
List tables in a DuckLake schema
db_upsert()
Upsert into a DuckLake table using MERGE INTO
db_vacuum()
Vacuum old snapshots from DuckLake
db_view_cols()
Get column names for a DuckLake view
run_example()
Run a package example script