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.

1.7 KB
Raw Blame
TOKEN "dub_tinybird_token" APPEND


SCHEMA >
    `timestamp` DateTime64(3) `json:$.timestamp` DEFAULT now(),
    `event_id` String `json:$.event_id`,
    `event_name` String `json:$.event_name`,
    `customer_id` String `json:$.customer_id`,
    `click_id` String `json:$.click_id`,
    `link_id` String `json:$.link_id`,
    `url` String `json:$.url`,
    `continent` LowCardinality(String) `json:$.continent`,
    `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`,
    `ip` String `json:$.ip`,
    `qr` UInt8 `json:$.qr`,
    `metadata` String `json:$.metadata`,
    `trigger` String `json:$.trigger`,
    `domain` Nullable(String) `json:$.domain`,
    `key` Nullable(String) `json:$.key`,
    `workspace_id` Nullable(String) `json:$.workspace_id`

ENGINE "MergeTree"
ENGINE_PARTITION_KEY "toYYYYMM(timestamp)"
ENGINE_SORTING_KEY "timestamp, link_id, customer_id"