Metrics Engine
In-memory SQL compliant metrics engine for advance analytics calculations, features or alert based triggers
Overview
This guide explains how to use the Metrics Engine by defining SQL expressions that store metrics and the runtime frequency using a policy.
Joule provides a SQL compliant metrics engine. The engine computes SQL query based metrics using a runtime policy using the events stored within auto generated event tables.
Key features
ANSI SQL compliant metrics calculation definition
Apply calculated metrics within processors
Pre-computed metrics import
Runtime policy
Metric management
Powered by the DuckDB In-memory column database
Example
Below computes a single family of metrics BidMovingAverage
at set time intervals and saved to an in-memory standardQuoteAnalyticsStream.BidMovingAverage
SQL table. The emit
definition performs a query lookup against eh table and returns the avg_bid_max
for each matching symbol.
Last updated