Skip to content

Open-source status page, incident response and uptime monitoring

435 B
Raw Blame
TOKEN "aggregate__requests_30d__v0_endpoint_read_7187" READ

NODE aggregate
SQL >

    SELECT
        toStartOfDay(toTimeZone(fromUnixTimestamp64Milli(cronTimestamp), 'UTC')) AS time,
        workspaceId,
        ifNull(trigger, 'cron') AS trigger,
        countState() AS count_state
    FROM ping_response__v8
    GROUP BY
        time,
        workspaceId,
        trigger

TYPE materialized
DATASOURCE mv__http_workspace_30d__v0