Build real-time decisions at any scale

-- Real-time transactions, partitioned by account
CREATE TABLE transactions (
  account_id BIGINT NOT NULL,
  amount     DECIMAL,
  txn_time   TIMESTAMP NOT NULL
);
PARTITION TABLE transactions ON COLUMN account_id;

-- Spend velocity for one account over the last 5 minutes
-- (catch many small charges adding up to a big spend)
CREATE PROCEDURE AccountSpend5Min
  PARTITION ON TABLE transactions COLUMN account_id AS
  SELECT COUNT(*) AS txns, SUM(amount) AS total
  FROM transactions
  WHERE account_id = ? AND txn_time > DATEADD(MINUTE, -5, NOW);

-- Score one account in a single-partition call
EXEC AccountSpend5Min 42;

-- Latency: 2.3ms ✓