Release· Databricks blog
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.
It gives SQL learners a named syntax for row-sequence pattern detection.