Skip to main content
Draxlr offers an intuitive interface for connecting to your ClickHouse database, enabling your team to explore, visualize, and publish insights within minutes. This guide will walk you through the steps to establish a successful connection.

​
  1. Get your ClickHouse credentials

To connect to ClickHouse with HTTP(S) you need this information:
Parameter(s)Description
HOST and PORTTypically, the port is 8443 when using TLS or 8123 when not using TLS.
DATABASE NAMEOut of the box, there is a database named default, use the name of the database that you want to connect to.
USERNAME and PASSWORDOut of the box, the username is default. Use the username appropriate for your use case.
The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console. Select a service and click Connect: Choose HTTPS. Connection details are displayed in an example curl command. If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.

​
  1. Connect Draxlr to ClickHouse

  1. Click on the Connect a Database button on the navbar.
  2. Select ClickHouse from the list of available databases and click next.
  3. Choose one of the hosting services and click next.
  4. Use any name in the Connection Name field.
  5. Add the connection details in the form.
  1. Click on the Next button and wait for the connection to be established. You will see the tables page if the connection is successful.

​
  1. Explore your data

  1. Click on one of the tables in the list.
  2. It will take you to the explore page to see the data in the table.
  3. You can start adding the filters, make joins and add sort to your data.
  1. You can also use the Graph button and select the graph type to visualize the data.

​
  1. Using SQL queries

  1. Click on the Explore button on the navbar.
  2. Click the Raw Query button and enter your query in the text area.
  1. Click on the Execute Query button to see the results.

​
  1. Saving you query

  1. After executing your query, click on the Save Query button.
  1. You can name to query in Query Name text box and select a folder to categories it.
  2. You can also use Add to dashboard option to add the result to dashboard.
  3. Click on the Save button to save the query.

​
  1. Building dashboards

  1. Click on the Dashboards button on the navbar.
  1. You can add a new dashboard by clicking on the Add + button on the left sidebar.
  2. To add a new widget, click on the Add button on the top right corner.
  3. You can select a query from the list of saved queries and choose the visualization type then click on the Add Dashboard Item button.

​
Learn more

To know more about Draxlr you can visit Draxlr documentation site.