| add_data_files | Register existing Parquet files with a DuckLake table |
| add_table_column | Add a column to a DuckLake table |
| attach_ducklake | Create or attach a ducklake |
| attach_quack | Connect to a remote Quack server |
| backup_ducklake | Create a DuckLake backup |
| begin_transaction | Begin a transaction |
| checkpoint_ducklake | Run a DuckLake checkpoint |
| cleanup_old_files | Delete files scheduled for removal |
| commit_transaction | Commit a transaction |
| create_storage_secret | Store object storage credentials for a session |
| create_table | Create a DuckLake table |
| create_view | Create a DuckLake view from a dplyr pipeline |
| delete_orphaned_files | Delete orphaned files |
| detach_ducklake | Detach from a ducklake |
| detach_quack | Disconnect from a remote Quack server |
| drop_table_column | Drop a column from a DuckLake table |
| drop_view | Drop a DuckLake view |
| ducklake_exec | Execute DuckLake operations from dplyr queries |
| ducklake_extension_available | Is the ducklake DuckDB extension usable? |
| expire_snapshots | Expire old snapshots |
| flush_inlined_data | Flush inlined data to Parquet files |
| get_ducklake_backend | Get the catalog backend type of an attached lake |
| get_ducklake_connection | Get the DuckDB connection used by ducklake |
| get_ducklake_options | List the options set on a DuckLake |
| get_ducklake_table | Get a DuckLake table |
| get_ducklake_table_asof | Query a table at a specific timestamp (time travel) |
| get_ducklake_table_version | Query a table at a specific version/snapshot |
| get_inlining_row_limit | Get the current data inlining row limit |
| get_metadata_table | Get a DuckLake metadata table |
| get_table_changes | Get the changes made to a table between two snapshots |
| get_table_comments | Read table, view, and column comments from a DuckLake catalog |
| get_table_info | Get file statistics for the tables in a lake |
| get_table_partitions | List the partitioning keys of tables in a lake |
| install_ducklake | Install the ducklake extension to duckdb |
| install_quack | Install the Quack extension |
| list_ducklake_files | List the data files backing a DuckLake table |
| list_ducklake_tables | List the tables and views in a DuckLake catalog |
| list_table_snapshots | List available snapshots for a table |
| merge_adjacent_files | Merge adjacent Parquet files |
| merge_into | Merge a source table into a DuckLake table |
| plot_snapshots | Plot the snapshot history of a table or lake |
| plot_table_changes | Plot the rows changed in each snapshot of a table |
| plot_table_files | Plot the file layout of a lake |
| quack_query | Run a one-off query against a remote Quack server |
| quack_serve | Serve the current session over Quack |
| quack_stop | Stop a Quack server |
| rename_ducklake_table | Rename a DuckLake table |
| rename_table_column | Rename a column in a DuckLake table |
| replace_table | Replace a table with modified data and create a new snapshot |
| reset_table_partitioning | Remove partitioning keys from a table |
| reset_table_sorting | Remove the sort order from a table |
| restore_table_version | Restore a table to a previous version |
| rewrite_data_files | Rewrite data files with many deletes |
| rollback_transaction | Rollback a transaction |
| rows_delete | Delete rows from a DuckLake table |
| rows_insert | Insert rows into a DuckLake table |
| rows_update | Update rows in a DuckLake table |
| rows_upsert | Upsert rows into a DuckLake table |
| set_column_comments | Set column comments on a DuckLake table |
| set_column_type | Change the type of a DuckLake table column |
| set_ducklake_connection | Use your own DuckDB connection with ducklake |
| set_ducklake_option | Set a DuckLake option |
| set_inlining_row_limit | Set the data inlining row limit |
| set_snapshot_metadata | Set metadata for the most recent snapshot |
| set_table_comment | Set the comment on a DuckLake table |
| set_table_partitioning | Set partitioning keys for a table |
| set_table_sorting | Set the sort order of a table |
| show_ducklake_query | Show the SQL that would be executed by ducklake operations |
| with_transaction | Execute code within a transaction |