Clickhouse extra SQL#

You can execute extra Clickhouse SQL at initialization. To do so, you need to use the patch clickhouse-extra-sql. This patch expects valid Clickhouse SQL code:

# Make sure to add a semi-colon at the end of every SQL statements
clickhouse-extra-sql: |
    CREATE TABLE IF NOT EXISTS {{ASPECTS_XAPI_DATABASE}}.{{ASPECTS_XAPI_TABLE}} (
        ...
    ) ENGINE = MergeTree()
    PARTITION BY toDate(timestamp)
    ORDER BY (timestamp, uuid)
    SETTINGS index_granularity = 8192;

    SELECT * from {{ASPECTS_XAPI_DATABASE}}.{{ASPECTS_XAPI_TABLE}} LIMIT 1;