The standard (default) mode of ai_extract now runs on a new model checkpoint that the release notes describe as 2.3x faster, with better overall quality and no extra cost. Queries that already use the default mode pick up the change without edits.
The Databricks platform, as it moves
News
From the official release notes and blog. Every item points at the concepts worth re-reading.
Latest stories
SQL
Release
Standard ai_extract moves to a faster model checkpoint
AI functions in SQLRead
SQL
Release
Built-in IP and CIDR functions are generally available on Databricks Runtime 18 LTS+
Databricks now ships native SQL, PySpark and Scala functions for IPv4 and IPv6 addresses and CIDR blocks: parsing, canonicalizing, inspecting, converting to binary, and ip_cidr_contains for containment joins. try_ variants return NULL on bad input instead of failing. They are generally available on Databricks Runtime 18 LTS and above.
Databricks blogRead
SQL
Release
SQL adds MATCH_RECOGNIZE for row-pattern matching
The blog introduces MATCH_RECOGNIZE as a SQL feature for detecting patterns across rows, described as similar to regex for rows. Learners working with event-style data, such as login attempts, should know the syntax exists before building pattern detection logic another way.
Spark SQL, the dialectRead
Everything, day by day
Tuesday 8 September
- time_bucket adds fixed-width timestamp buckets in SQLDatabricks SQL now has the time_bucket function, which returns the start of the fixed-width interval that contains a timestamp. Use it instead of date_trunc when the bucket width or bucket origin is not a calendar unit.
- time_bucket rounds a timestamp to a fixed windowThe function returns the start of the fixed-width interval a timestamp falls into, aligned to an origin you choose. Generally available, and it removes the date_trunc-and-arithmetic dance from most time-series grouping.
Wednesday 1 July
- Transactions are GA for Unity Catalog managed tablesMulti-statement, multi-table ACID transactions reached general availability in Databricks. On Unity Catalog managed tables, SQL changes can be grouped with BEGIN ATOMIC ... END or BEGIN TRANSACTION ... COMMIT so the changes commit together or roll back together.
- VARIANT reached general availability in DatabricksVARIANT reached general availability in Databricks in July 2026. It is a column type for semi-structured, JSON-shaped data without a declared schema, created with parse_json() and queried by path.
Nothing of that kind yet.