Clickhouse queries (DBeaver)
Last updated
Last updated
DBeaver is a powerful, open-source tool for managing and querying Clickhouse databases. Its intuitive interface allows you to connect to the Indexer’s database, write and execute Clickhouse queries, and analyze results with ease. This chapter guides you through setting up DBeaver, exploring table schemas, and running queries to extract actionable insights tailored to your analytical needs.
To start querying the indexer’s Clickhouse database, follow these steps to configure DBeaver:
Install DBeaver: Download and install the latest version of DBeaver Community Edition from .
Create a New Connection:
Open DBeaver and click Database > New Connection.
Select Clickhouse from the list of drivers. If the driver isn’t available, download it via DBeaver’s driver manager.
Enter Connection Details:
Use the server link below, login, and password provided (server link: )
Set the database name to the one specified in your credentials.
Test the connection to ensure it’s successful.
Save and Connect: Save the configuration and connect to the database. You’ll see the database schema in DBeaver’s Database Navigator.
Understanding the database structure is key to writing effective queries. To generate a table’s schema:
Navigate to the database and select the table for which you want to generate the SQL schema.
Right-click on the table and choose Generate SQL.
Select DDL (Data Definition Language) to generate the table’s structure as a SQL statement.
The SQL script will be automatically generated, showing the table’s structure.
Once you’ve generated the schema, you can write complex queries to select and filter relevant data from the tables, perform calculations, and extract necessary information. This allows you to manipulate and analyze the data according to your specific needs.
With the schema in hand, you can write Clickhouse queries to extract and analyze data.
Check out SQL query examples for and