Skip to content

armgit / dub

Public Imported from GitHub
0

The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.

926 B
Raw Blame
TOKEN "dub_tinybird_token" APPEND


SCHEMA >
    `id` String `json:$.id`,
    `timestamp` DateTime64(3) `json:$.timestamp`,
    `workspace_id` String `json:$.workspace_id`,
    `method` LowCardinality(String) `json:$.method`,
    `path` String `json:$.path`,
    `route_pattern` LowCardinality(String) `json:$.route_pattern`,
    `status_code` UInt16 `json:$.status_code`,
    `duration` UInt32 `json:$.duration`,
    `user_agent` String `json:$.user_agent`,
    `request_body` String `json:$.request_body`,
    `query_params` String `json:$.query_params` DEFAULT '',
    `response_body` String `json:$.response_body`,
    `token_id` String `json:$.token_id`,
    `user_id` String `json:$.user_id`,
    `request_type` LowCardinality(String) `json:$.request_type`

ENGINE "MergeTree"
ENGINE_PARTITION_KEY "toYYYYMM(timestamp)"
ENGINE_SORTING_KEY "workspace_id, timestamp"
ENGINE_TTL "toDateTime(timestamp) + toIntervalDay(90)"