packages/tinybird/pipes/aggregate__http_status_7d.pipe at main

openstatus.dev / openstatus

fork atom

Openstatus www.openstatus.dev

fork atom

openstatus / packages / tinybird / pipes / aggregate__http_status_7d.pipe

at main 19 lines 381 B view raw

wrap content

Ramtin Mesgari Containerize core services (#1585) 4mo ago

b4577f2e

 1VERSION 0
 2
 3TAGS http, statuspage
 4
 5NODE aggregate
 6SQL >
 7
 8    SELECT
 9        toStartOfDay(toTimeZone(fromUnixTimestamp64Milli(cronTimestamp), 'UTC')) AS time,
10        monitorId,
11        countState() AS count,
12        countState(if(error = 0, 1, NULL)) AS ok
13    FROM ping_response__v8
14    GROUP BY
15        time,
16        monitorId
17
18TYPE materialized
19DATASOURCE mv__http_status_7d__v0