ClickHouse + Bruin 101
1) Initialize the template
Run bruin init from the directory where you keep pipeline projects:
bruin init clickhouse clickhouse-bruin-101
cd clickhouse-bruin-101
bruin init copies a working project instead of generating a blank directory. That means the connection name, asset names, dependency graph, checks, test, and sample data already agree with one another. The general template tutorial covers the same command with a smaller example.
The command has two arguments after init:
clickhouseselects Bruin's ClickHouse template.clickhouse-bruin-101is the directory Bruin creates. It is also the project directory used in the commands later in this guide.
The current feature-showcase template has this shape:
clickhouse-bruin-101/
├── .bruin.yml
├── pipeline.yml
└── assets/
├── data_definitions/
├── ingestion/
├── materialization_types/
└── python/
If you instead see only example_a.sql through example_d.sql, your installed CLI has an older copy of the template. Update the CLI using the installation instructions, then initialize a fresh project. This guide follows the current ClickHouse template reference.