Skip to content

The open alternative to Salesforce, designed for AI.

349 B
Raw Blame
CREATE TABLE IF NOT EXISTS pageview
(
    `name`        LowCardinality(String) NOT NULL,
    `timestamp`   DateTime64(3) NOT NULL,
    `userId`      String DEFAULT '',
    `workspaceId` String DEFAULT '',
    `properties`  JSON
)
    ENGINE = MergeTree
    ORDER BY (workspaceId, timestamp, name, userId)
    TTL timestamp + INTERVAL 3 YEAR DELETE;