SQL
ReleaseWorth evaluating
SQL adds MATCH_RECOGNIZE for row-pattern matching
From Databricks blog
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.
What to re-read
More from SQL
- ReleaseDocument Intelligence REST APIs for parse, extract and classify reach GA
- PreviewPredictive AI Functions enter Beta: forecasting, anomalies and predictions in SQL
- Releaseai_parse_document now returns chart values as structured JSON
- ReleaseStandard ai_extract moves to a faster model checkpoint