Lakehouse Real-Time

Databricks puts MATCH_RECOGNIZE in its compute with the failure window anchored inside DEFINE

Databricks says the clause is now available in its compute, including Lakehouse Real-Time. In the DEFINE block, FIRST(FAIL.event_time) pins an hour-long window to the first failure of each match.