08bf49eaec
ref https://linear.app/tryghost/issue/ANAL-27/setup-tinybird-project-and-cicd ref https://github.com/tinybirdco/web-analytics-starter-kit/blob/main/tinybird/pipes/analytics_sessions.pipe - These datasources and pipes work together to define the main endpoints we need for our stats dashboard - They are based on the web analytics starter kit from tinybird - We've updated them to handle site_uuid - There's more to do to pipe the member-related and post-related data through the system yet
15 lines
492 B
Plaintext
15 lines
492 B
Plaintext
SCHEMA >
|
|
`site_uuid` String,
|
|
`date` Date,
|
|
`session_id` String,
|
|
`device` SimpleAggregateFunction(any, String),
|
|
`browser` SimpleAggregateFunction(any, String),
|
|
`location` SimpleAggregateFunction(any, String),
|
|
`first_hit` SimpleAggregateFunction(min, DateTime),
|
|
`latest_hit` SimpleAggregateFunction(max, DateTime),
|
|
`hits` AggregateFunction(count)
|
|
|
|
ENGINE AggregatingMergeTree
|
|
ENGINE_PARTITION_KEY toYYYYMM(date)
|
|
ENGINE_SORTING_KEY date, session_id, site_uuid
|