sql-match-recognize - Detect ordered row patterns with MATCH_RECOGNIZE
Guides SQL:2016 MATCH_RECOGNIZE for detecting patterns across ordered rows, including trend reversals, threshold breaches, and complex sessionization.
Tags
Updated: 2026-10-03Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Check engine support
- Define row predicates
- Compose regex row patterns
- Project match measures
- Control match output
- Select match skip behavior
Inputs
- Target SQL engine
- Time-series table
- Partition columns
- Ordering columns
- Row pattern criteria
Outputs
- MATCH_RECOGNIZE query
- Pattern match result rows
Requirements
- SQL engine support for MATCH_RECOGNIZE
- Ordered input rows
- SQL query execution environment