Manage Aiven for ClickHouse® integration databases

Set up and manage Aiven for ClickHouse® integration databases to access data hosted by services you're integrated with.

By adding integrations databases in Aiven for ClickHouse, you create streaming data pipelines across services. From Aiven for ClickHouse, you can add integration databases connecting to:

• Aiven for Apache Kafka®
• Aiven for PostgreSQL®

Prerequisites

• Access to the Aiven Console
• Running Aiven for ClickHouse service
• Service integration between the Aiven for ClickHouse service and a data source service (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. On your service's page, click Databases and tables in the sidebar.

4. On the Databases and tables page, click Create database > PostgreSQL integration database.

5. In the Create PostgreSQL integration database wizard:

   1. Select a service to be a data source for the integration database, 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. On your service's page, click Integrations in the sidebar.

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 a service to be a data source for the integration database, and click Continue.
   2. Set up the integration table details:
      • 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

To preview integration databases or tables for your Aiven for ClickHouse service:

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service to preview data structures for.
3. On your service's page, click Databases and tables in the sidebar.
4. Find your integration database, and expand it using to display tables inside it.
5. Find your table, and click Actions > View details.

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 that includes a database to be edited.
3. On your service's page, click Databases and tables in the sidebar.
4. Find the integration database to be edited, and click Actions > Edit database.
5. Add or delete integration databases using or Delete respectively, and click Save.

Alternative for PostgreSQL

Go to your Aiven for ClickHouse service's Integrations page, find an 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 that includes a database where you intend to add or delete tables.
3. On your service's page, click Databases and tables in the sidebar.
4. Find the database, and click Actions > Edit database.
5. Add or delete tables using Add table or Delete respectively, 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 that includes a table to be edited.
3. On your service's page, click Databases and tables in the sidebar.
4. Find a database including the table to be edited, and expand the database using to display tables inside it.
5. Find the table to be edited, and click Actions > Edit table.
6. In the Edit table window, update table details, and click Saves.

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 where a database to be deleted resides.
3. On your service's page, click Databases and tables in the sidebar.
4. On the Databases and tables page, find your integration database and click Actions > Delete database.
5. In the Delete database confirmation window, study the impact and click Confirm if you accept removing the database along with the tables inside it.

Table

1. Log in to the Aiven Console, and go to your project.
2. On the Services page, select an Aiven for ClickHouse service where a table to be deleted resides.
3. On your service's page, click Databases and tables in the sidebar.
4. Find the integration database including the table, and expand it using to display tables inside it.
5. Find the table to be deleted, and click Actions > Delete table.
6. In the Delete table confirmation window, study the impact and click Confirm if you accept removing the table.

Related pages

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