ghost/tinybird/datasources/analytics_events.datasource from TryGhost/Ghost

ghost/tinybird/datasources/analytics_events.datasource

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

DESCRIPTION >
    Analytics events landing data source

TOKEN "tracker" APPEND

SCHEMA >
    `timestamp` DateTime `json:$.timestamp`,
    `session_id` String `json:$.session_id`,
    `action` LowCardinality(String) `json:$.action`,
    `version` LowCardinality(String) `json:$.version`,
    `payload` String `json:$.payload`

ENGINE MergeTree
ENGINE_PARTITION_KEY toYYYYMM(timestamp)
ENGINE_SORTING_KEY timestamp
ENGINE_TTL timestamp + toIntervalDay(60)