Create and manage Aiven for ClickHouse® integration databases

Create and manage integration databases in Aiven for ClickHouse® to query data from integrated services:

• Aiven for Apache Kafka®
• Aiven for PostgreSQL®

Prerequisites

• Access to the Aiven Console
• An Aiven for ClickHouse service
• A service integration with Aiven for Kafka or Aiven for PostgreSQL

Create integration databases

note

Your Aiven for ClickHouse service can support up to 400 databases simultaneously.

Depending on your data source, select PostgreSQL or Apache Kafka.

PostgreSQL

1. Log in to the Aiven Console, and go to your project.

2. On the Services page, select an Aiven for ClickHouse service.

3. In the sidebar, click Databases and tables.

4. Click Create database > PostgreSQL integration database.

5. In the Create PostgreSQL integration database wizard:

   1. Select the data source service, and click Continue.
   2. Enter Database name and Schema name, and click Save.

Apache Kafka

1. Log in to the Aiven Console, and go to your project.

2. On the Services page, select an Aiven for ClickHouse service.

3. In the sidebar, click Integrations.

4. On the Integrations page, find your data source integration and click Actions > Create database.

5. In the Create Kafka integration database wizard:

   1. Select the data source service, and click Continue.
   2. Configure the integration table:
      • Enter a table name.
      • Enter a consumer group name.
      • Select topics.
      • Select a data format.
      • Enter table columns.
   3. Click Save table details > Save.

View integration databases or tables

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service.
3. In the sidebar, click Databases and tables.
4. Expand the integration database using .
5. Click Actions > View details on the table.

Edit integration databases or tables

Add or delete integration databases or tables. Update table details.

note

You cannot edit tables inside PostgreSQL integration databases.

Depending on what you intend to edit, select Database or Table.

Database

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service with the database.
3. In the sidebar, click Databases and tables.
4. Click Actions > Edit database on the integration database.
5. Use or Delete to add or remove integration databases, and click Save.

Alternative for PostgreSQL

On the Integrations page, find the integration and click Actions > Edit database.

Table

Add or delete tables

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service with the database.
3. In the sidebar, click Databases and tables.
4. Click Actions > Edit database on the database.
5. Use Add table or Delete to add or remove tables, and click Save.

Update table details

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service with the table.
3. In the sidebar, click Databases and tables.
4. Expand the database using .
5. Click Actions > Edit table on the table.
6. Update the table details, and click Save.

Delete integration databases or tables

Depending on what you intend to delete, select Database or Table.

Database

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service with the database.
3. In the sidebar, click Databases and tables.
4. Click Actions > Delete database on the integration database.
5. Review the impact in the confirmation dialog, and click Confirm to delete the database and its tables.

Table

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service with the table.
3. In the sidebar, click Databases and tables.
4. Expand the integration database using .
5. Click Actions > Delete table on the table.
6. Review the impact in the confirmation dialog, and click Confirm to delete the table.

Related pages

• Manage Aiven for ClickHouse® data service integrations
• Aiven for ClickHouse® service integrations