Create ci_finished_pipelines table
In order to perform analytics on pipelines, we need to have the finished pipelines data in ClickHouse. For that, we'll need to create a ci_finished_pipelines
, similar to ci_finished_builds
:
CREATE TABLE ci_finished_pipelines
(
`id` UInt64 DEFAULT 0,
`path` String DEFAULT '0/',
`committed_at` DateTime64(6, 'UTC') DEFAULT 0,
`created_at` DateTime64(6, 'UTC') DEFAULT 0,
`started_at` DateTime64(6, 'UTC') DEFAULT 0,
`finished_at` DateTime64(6, 'UTC') DEFAULT 0,
`duration` UInt64 DEFAULT 0,
`date` Date32 MATERIALIZED toStartOfMonth(finished_at),
`status` LowCardinality(String) DEFAULT '',
`source` LowCardinality(String) DEFAULT '',
`ref` String DEFAULT ''
)
ENGINE = ReplacingMergeTree
PARTITION BY toYear(finished_at)
ORDER BY (id)
Edited by Pedro Pombeiro