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#
Log in to the Aiven web console.
Follow these instructions to create a new ClickHouse service.
Once the service is ready, the status changes to Running. This typically takes a couple of minutes, depending on your selected cloud provider and region.
Create a database#
When the service is running, go to the Databases & Tables tab.
Enter a name for your database, then click 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 tab and copy the Host, Port, User, and Password parameters that 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.