Home / Companies / ClickHouse / Blog / Post Details
Content Deep Dive

New Terraform provider: Manage ClickHouse database users, roles, and privileges with code

Blog post from ClickHouse

Post Details
Company
Date Published
Author
Ryan Sickles
Word Count
1,367
Language
English
Hacker News Points
-
Summary

The new Terraform provider, clickhousedbops, has been launched to facilitate the management of database users, roles, and privileges for ClickHouse instances, whether on ClickHouse Cloud or self-hosted. This provider enhances existing Terraform functionalities by allowing users to programmatically automate configuration and management of their ClickHouse services, which simplifies maintaining the state across different environments. Users can define connections to ClickHouse instances, create databases, and assign users and roles with specific privileges. A practical example demonstrates setting up a ClickHouse Cloud service for log analytics and managing user access through Terraform. The provider also supports self-hosted ClickHouse deployments, allowing resource creation across multiple replicas in a cluster. Feedback is encouraged through GitHub repositories to improve the offering.