Configure the ClickHouse driver for Grafana

TrafficPeak includes a pre-configured Grafana installation. If you want to use another instance of Grafana that’s not automatically configured to query your TrafficPeak database, follow these steps to connect it.

Add a new ClickHouse connection

You must have administrator access to your Grafana instance to connect to TrafficPeak.

1. Click Connections in the left-hand menu.

2. Select Add new connection and filter for “ClickHouse.”

   You will see several options, but the one you want to use is the “ClickHouse” data source with the yellow logo.

   

3. Select it, and click the Install button in the upper right-hand corner.

   

Configure a new data source

Configure a new data source by clicking the button.

While configuring, do these things.

1. Enter a unique name for this TrafficPeak connection.

2. Enter your TrafficPeak hostname for the server address. It will follow this format: <host>.TrafficPeak.live. If you don't have this information, reach out to your TrafficPeak service representative. If you are on a shared infrastructure, it will look like an airport code as the hostname, such as ord.TrafficPeak.live or ams.TrafficPeak.live.

3. Enter 9440 for server port.

4. Select the Native protocol.

5. Enable Secure Connection.

   

6. Enter a default database that contains the data you would like to visualize.

7. Click Save & test to verify the connection.

   

If you’ve configured everything correctly, you should see a "Data source is working" notification: