In this repository you will find a series of tutorials, described in different Medium posts, to integrate ClickHouse with different tools such as Terraform, dbt, Metabase, etc. The configurations used in these tutorials are completely based on my experience and requirements needed at the time of development. Therefore, I strongly encourage you to use these scripts as guides for your first steps.
In the clickhouse_terraform folder you'll find scripts required to integrate ClickHouse with Terraform and Kubernetes through helm charts. For more context feel free to read the original medium post!
In the clickhouse_users folder you can find the original scripts from clickhouse_terraform with the necessary modifications to create new users with the required grants according to the needs of each one of them. If you want a detailed explanation of the new configs you can always consult the original post, Creating multiple users in ClickHouse from Terraform.
Within the ch_dbt folder you will find scripts and files to create, connect and configure your first dbt project with ClickHouse. Moreover, you will also find some csv files as well as sql script examples for you to create your first dbt seeds and dbt models. For a detailed explanation of the code, please refer to the part 1, part 2 and part 3 of my medium posts where I provide an easy guide for the ClickHouse + dbt integration.