DuckDB Foundation – DuckDB
The independent non-profit DuckDB Foundation safeguards the long-term maintenance and development of DuckDB.| DuckDB
The independent non-profit DuckDB Foundation safeguards the long-term maintenance and development of DuckDB.| DuckDB
The iceberg extension implements support for the Apache Iceberg open table format and can connect to Iceberg REST Catalogs. For information on how to connect to an Iceberg REST Catalog, please see the Iceberg REST Catalogs page. Installing and Loading To install the iceberg extension, run: INSTALL iceberg; Note that the iceberg extension is not autoloadable. Therefore, you need to load it before using it: LOAD iceberg; Updating the Extension The iceberg extension often receives updates betwee...| DuckDB
The delta extension adds support for the Delta Lake open-source storage format. It is built using the Delta Kernel. The extension offers read support for Delta tables, both local and remote. For implementation details, see the announcement blog post. Warning The delta extension is currently experimental and is only supported on given platforms. Installing and Loading The delta extension will be transparently autoloaded on first use from the official extension repository. If you would like to ...| DuckDB
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.3.0, codenamed “Ossivalis”.| DuckDB
The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple tables that are joined together using JOIN clauses, or another SELECT query inside a subquery node. DuckDB also has an optional FROM-first syntax which enables you to also query without a SELECT statement. Examples Select all columns from the table called table_...| DuckDB
DuckLake has been released in May 2025. Read the announcement blog post. The ducklake extension add support for attaching to databases stored in the DuckLake format: Installing and Loading To install ducklake, run: INSTALL ducklake; The ducklake extension will be transparently autoloaded on first use in an ATTACH clause. If you would like to load it manually, run: LOAD ducklake; Usage ATTACH 'ducklake:metadata.ducklake' AS my_ducklake (DATA_PATH 'data_files'); USE my_ducklake; Tables In DuckD...| DuckDB
