Bruin CLI Step 1 of 6

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:

  • clickhouse selects Bruin's ClickHouse template.
  • clickhouse-bruin-101 is 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.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.