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 >
`timestamp` DateTime64(3) `json:$.timestamp`,
`click_id` String `json:$.click_id`,
`link_id` String `json:$.link_id`,
`alias_link_id` Nullable(String) `json:$.alias_link_id`,
`url` String `json:$.url`,
`country` LowCardinality(String) `json:$.country`,
`city` String `json:$.city`,
`region` String `json:$.region`,
`latitude` String `json:$.latitude`,
`longitude` String `json:$.longitude`,
`device` LowCardinality(String) `json:$.device`,
`device_model` LowCardinality(String) `json:$.device_model`,
`device_vendor` LowCardinality(String) `json:$.device_vendor`,
`browser` LowCardinality(String) `json:$.browser`,
`browser_version` String `json:$.browser_version`,
`os` LowCardinality(String) `json:$.os`,
`os_version` String `json:$.os_version`,
`engine` LowCardinality(String) `json:$.engine`,
`engine_version` String `json:$.engine_version`,
`cpu_architecture` LowCardinality(String) `json:$.cpu_architecture`,
`ua` String `json:$.ua`,
`bot` UInt8 `json:$.bot`,
`referer` String `json:$.referer`,
`referer_url` String `json:$.referer_url`,
`user_id` Nullable(Int64) `json:$.user_id`,
`identity_hash` Nullable(String) `json:$.identity_hash`,
`ip` String `json:$.ip`,
`qr` UInt8 `json:$.qr`,
`continent` LowCardinality(String) `json:$.continent`,
`vercel_region` Nullable(String) `json:$.vercel_region`,
`trigger` String `json:$.trigger`,
`workspace_id` Nullable(String) `json:$.workspace_id`,
`domain` Nullable(String) `json:$.domain`,
`key` Nullable(String) `json:$.key`
ENGINE "MergeTree"
ENGINE_PARTITION_KEY "toYYYYMM(timestamp)"
ENGINE_SORTING_KEY "timestamp, link_id, click_id"