Patterns

The following section provides examples of implementing some common query patterns in Materialize:

Durable subscriptions

Percentile calculation

Rules execution engine

Temporal filters (time windows)

Top K by group

Window functions (OVER clause)