Aiven for ClickHouse® quickstart guide#
The first step in using Aiven for ClickHouse® is to create a service and a database that you can use to try out the service. You can do this in the Aiven web console.
This example shows you how to create a new service, add a database to it, and use Docker to connect to the service with the ClickHouse client.
Create a ClickHouse service#
Create a database#
When the service is running, select Databases and tables from the sidebar of your service’s page.
In the Databases and tables page, select Create database > ClickHouse database.
In the Create ClickHouse database window, enter a name for your database and select Create database.
All databases must be created through the web console.
Connect to ClickHouse#
Get the latest Docker image of the ClickHouse client from Docker Hub
Go to the Overview page of your service, and copy the Host, Port, User, and Password, which you need for connecting to the service.
Run the following command to connect to your service and run SQL queries on your database, substitute the placeholders for
docker run -it \ --rm clickhouse/clickhouse-client \ --user USERNAME \ --password PASSWORD \ --host HOST \ --port PORT \ --secure
For more information on using the ClickHouse client, see this article.
Now that you have your service and connection set up, see our sample dataset article to try out your service with actual data.