Manage your Aiven for ClickHouse® service

Secure a managed ClickHouse® service

You can secure your Aiven for ClickHouse® service in a few different

Manage users and roles

Create Aiven for ClickHouse® users and roles and grant them specific privileges to efficiently control or restrict access to your service.

Manage ClickHouse® databases and tables

Create and work with databases and tables in Aiven for ClickHouse®.

Query ClickHouse® databases

There are a few tools that enable querying ClickHouse® databases. Find out which of them are supported in Aiven and how to use them.

Create materialized views in ClickHouse®

Learn how to create and use materialized views to persist data from the

Monitor Aiven for ClickHouse® metrics with Grafana®

As well as offering ClickHouse®-as-a-service, the Aiven platform gives

Enable reading and writing data across shards in Aiven for ClickHouse®

If your Aiven for ClickHouse® service uses multiple shards, the data is replicated only between nodes of the same shard.

Copy data from one ClickHouse® server to another

You can copy data from one ClickHouse® server to another using the

Fetch query statistics for Aiven for ClickHouse®

About fetching query statistics

Read and pull data from S3 object storages and web resources over HTTP

With federated queries in Aiven for ClickHouse®, you can read and pull

Create dictionaries

Create dictionaries in Aiven for ClickHouse® to accelerate queries for better efficiency and performance.

SQL UDFs

Use SQL user defined functions (UDFs) in Aiven for ClickHouse® to speed up your queries