Skip to main content

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.

  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.

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.

  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 clicking click Actions > Edit database.

Delete integration databases or tables

Depending on what you intend to delete, select Database or 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 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.

Related pages