Quick Demo

If you want to try the datasource, please follow the easy steps of this quick demo:

Prerequisites

• docker
• docker-compose

Instructions

1. Download the repository using git clone (simple archive download will work too)

git clone https://github.com/HadesArchitect/GrafanaCassandraDatasource.git 
cd GrafanaCassandraDatasource

2. Launch the project

docker-compose up -d

3. Wait for Cassandra to start, it may take a bit

Check the status with the command docker-compose exec cassandra nodetool status | grep rack1. As soon as the output looks like UN 172.23.0.3 88.16 KiB ... (UN means UP and NORMAL), you are good to go

4. Load sample data

docker-compose exec cassandra cqlsh -u cassandra -p cassandra -f ./test_data.cql

5. Add the datasource

Open the link http://localhost:3000/datasources/new and select the Apache Cassandra datasource. In the new window, specify following details: host is cassandra:9042, others empty.

Save and test!

6. Add the panel

Follow the link http://localhost:3000/dashboard/new and push the Add new panel button.

7. Add the first query using Query Configurator, the simplest way to query data

• Keyspace test
• Table test
• Time Column created_at
• Value Column value
• ID Column id
• ID Value 99051fe9-6a9c-46c2-b949-38ef78858dd0

8. Add the second query using Query Editor, the more powerful way to query data with direct access to CQL

First, press the + Query button

Then, switch the new query to the query editor mode pushing the toggle text edit mode button.

In the Raq CQL field, specify the query:

SELECT id, CAST(value as double), created_at FROM test.test WHERE id IN (99051fe9-6a9c-46c2-b949-38ef78858dd1) AND created_at > $__timeFrom and created_at < $__timeTo

That's it, you made it!