splink_udfs – DuckDB Community Extensions
DuckDB Community Extensions Phonetic, text normalization and address matching functions for record linkage.| DuckDB
Redirecting…| duckdb.org
Redirecting…| duckdb.org
DuckDB Community Extensions Phonetic, text normalization and address matching functions for record linkage.| DuckDB
DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, fast & open source.| DuckDB
We're releasing DuckDB version 1.4.0, codenamed “Andium”. This is an LTS release with one year of community support, and it packs several new features including database encryption, the MERGE statement and Iceberg writes.| DuckDB
DuckDB v1.3.0 significantly improved the scalability of geospatial joins with a dedicated SPATIAL_JOIN operator.| DuckDB
List of Core Extensions Name GitHub Description Stage Aliases autocomplete Adds support for autocomplete in the shell stable avro GitHub Add support for reading Avro files stable aws GitHub Provides features that depend on the AWS SDK stable azure GitHub Adds a filesystem abstraction for Azure blob storage to DuckDB stable delta GitHub Adds support for Delta Lake experimental ducklake GitHub Adds support for DuckLake experimental encodings GitHub Adds support for encoding...| 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
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
DuckLake simplifies lakehouses by using a standard SQL database for all metadata, instead of complex file-based systems, while still storing data in open formats like Parquet. This makes it more reliable, faster, and easier to manage.| DuckDB
DuckDB continues to push the boundaries of SQL syntax to both simplify queries and make more advanced analyses possible. Highlights include dynamic column selection, queries that start with the FROM clause, function chaining, and list comprehensions. We boldly go where no SQL engine has gone before! For more details, see the documentation for friendly SQL features.| DuckDB
We've resurrected the H2O.ai database-like ops benchmark with up to date libraries and plan to keep re-running it.| DuckDB
We are happy to announce a new preview feature that adds support for Apache Iceberg REST Catalogs, enabling DuckDB users to connect to Amazon S3 Tables and Amazon SageMaker Lakehouse with ease.| DuckDB
The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.| DuckDB
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.2.0, codenamed “Histrionicus”.| DuckDB
Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Return only the regions that have a sum of amount higher than 100: SELECT region FROM sales GROUP BY region HAVING sum(amount) > 100; Return the number of unique values in the region column: SELECT count(DISTINCT region) FROM sales; Return two values, the tota...| DuckDB
The zero-copy integration between DuckDB and Apache Arrow allows for rapid analysis of larger than memory datasets in Python and R using either SQL or relational APIs.| DuckDB
Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITER '|'); Read a Parquet file into the lineitem table: COPY lineitem FROM 'lineitem.pq' (FORMAT PARQUET); Read a JSON file into the lineitem table, using auto-detected options: COPY lineitem FROM 'lineitem.json' (FORMAT JSON, AUTO_DETECT true); Read a CSV fil...| DuckDB
DuckDB, a free and open source analytical data management system, can run SQL queries directly on Parquet files and automatically take advantage of the advanced features of the Parquet format.| DuckDB
Function Syntax Function Chaining via the Dot Operator DuckDB supports the dot syntax for function chaining. This allows the function call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...). For example, take the following use of the replace function: SELECT replace(goose_name, 'goose', 'duck') AS duck_name FROM unnest(['African goose', 'Faroese goose', 'Hungarian goose', 'Pomeranian goose']) breed(goose_name); This can be rewritten as follows: SELECT goose_name.replace('go...| DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.| DuckDB
DuckDB is an in-process SQL database management system focused on analytical query processing. It is designed to be easy to install and easy to use. DuckDB has no external dependencies. DuckDB has bindings for C/C++, Python, R, Java, Node.js, Go and other languages.| DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.| DuckDB
