SQL Clients > Grafana

Grafana

This page describes how to set up the Rockset Grafana connector.

The steps below require that you have a Rockset account. You can create an account here.

Introduction

Grafana is an open source platform for analytics and monitoring. Grafana + Rockset is ideal for things like creating visualizations on your Rockset collections and plotting timeseries data.

Configuration

  1. Create an API Key using the Rockset Console under Manage > API Keys.

Rockset API Keys

  1. Set up Grafana if you have not already. The Grafana website has detailed instructions here

  2. use the grafana-cli to install your plugin. You can download the rockset plugin by using the command grafana-cli --pluginUrl https://github.com/rockset/rockset-grafana/archive/<LATEST_RELEASE>.zip plugins install rockset-grafana-rockset. where LATEST_RELEASE is the most recent release from here.

  1. From your grafana homepage, go to /datasources. You can type this in your browser, or click on the gear on the left side of the screen and click “Data Sources” under the configuration menu.
Grafana datasource selection
  1. Type ‘Rockset’ into the search bar with placeholder text "Filter by name or type", and click on the Rockset data source.
Grafana add datasource
  1. Enter your API key and name your connector, then press "Save & Test". If you get an authentication failure, ensure your API key was pasted correctly
Grafana enter details

Usage

  1. Click on the plus on the left side of the screen, and click on “Dashboard” under the create menu.
Grafana select dashboard
  1. Click on “Add Query” in the new panel.
Grafana new panel
  1. Select your Rockset data source next to the “Query” section of your panel view.
Grafana query editor
  1. Enter your Rockset query into the text field. This query can be any SQL statement that is valid in the Rockset Console, but if you are using a graph visualization, you need a timeseries field. Let’s use the query SELECT _event_time, COUNT(*) FROM _events GROUP BY _event_time LIMIT 100; where _event_time is a timeseries field.
Grafana full query
  1. (Optional) Select which of your fields is the timeseries field in the "Timeseries field (optional)" text area. If you have only one field that is stored as a datetime string, the connector should parse it for you. Otherwise, you will need to specify which field you want to see. Let’s try a query with two timeseries fields.
Grafana optional query
  1. (Optional) Choose a visualization from the visualization tab on the left of the screen to format your data in different ways.

  2. You should now be able to see your results and save your panel!

Grafana results