The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.
TypeScript clickhousemysqlnextjsopen-sourceplanetscaleprismatailwindcsstinybirdtypescriptupstashvercel
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)"