Databricks SQL version 2026.20 is now available in the Preview channel. Review the following section to learn about new features, behavioral changes, and bug fixes.
New IP address functions
A set of SQL functions is now available for working with IPv4 and IPv6 addresses and CIDR blocks, including ip_host, ip_cidr, ip_version, ip_prefix_length, ip_network, ip_network_last, ip_cidr_contains, ip_as_binary, and ip_as_string, along with try_* variants for null-safe behavior. See ip_host function.
NEAREST BY join type
NEAREST BY is now a supported SQL join type for top-K nearest-neighbor queries. See NEAREST BY clause.
DESCRIBE TABLE PARTITION support for v2 catalog tables
DESCRIBE TABLE ... PARTITION is now supported for v2 catalog tables. Previously, this syntax was available only for v1 tables. See DESCRIBE TABLE.
QUALIFY clause
SQL queries now support a QUALIFY clause, which lets you filter on window function results directly in the query. Previously, this required wrapping the query in a subquery. See Window functions.
DESCRIBE EXTENDED AS JSON includes predictive optimization results …