ClickHouse Playground
A fast, open-source, column-oriented, analytical database.
Connecting to ClickHouse
To connect to ClickHouse, use the following command from the terminal:
clickhouse-client
Connecting from other clients
If you need to connect from another client, use the following credentials:
- Username:
default - Password:
iximiuz
Writing and Running Queries
A good way to write queries is using the built-in IDE and saving them to files.
Then in the terminal, you can run the saved queries using the following command:
clickhouse-client < query.sql
If you have multiple queries in a file, you can run them all at once using the following command:
clickhouse-client --multiquery < queries.sql
Accessing ClickHouse through a UI
ClickHouse offers a powerful UI for their Cloud solution, but there is no UI included in the self-hosted version.
You can use any of the third-party interfaces. One of the most popular one is CH-UI.
You can easily run it on your local machine, expose the ClickHouse web interface and connect to it from your browser.
Learning ClickHouse
ClickHouse offers excellent training materials. You can use this playground for the hands-on exercises.
You can read more about learning ClickHouse in this post.