Skip to content

MATCH_RECOGNIZE

Beta
Last seen at this status: 2026-06-30·Jun 2026

A SQL:2016 clause that finds row patterns in ordered data, such as runs of consecutive values or V-shaped price moves, and returns one row per match or every matching row. It works in Databricks SQL and Databricks Runtime 19.0 and above once a workspace admin turns on the Match Recognize preview.

Status history

  • Beta
    2026-06-30 · Jun 2026
    Release notes

    Verified on 2026-10-15 against Databricks sources.

Sources (1)

Status and dates are extracted from public sources only. We don't see the private AE-shared roadmap. If something looks wrong, tell us.