Quick Demo
If you want to try the datasource, please follow the easy steps of this quick demo:
- docker
- docker-compose
- Download the repository using
git clone(simple archive download will work too)
git clone https://github.com/HadesArchitect/GrafanaCassandraDatasource.git
cd GrafanaCassandraDatasource
- Launch the project
docker-compose up -d
- 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
- Load sample data
docker-compose exec cassandra cqlsh -u cassandra -p cassandra -f ./test_data.cql
- 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!
- Add the panel
Follow the link http://localhost:3000/dashboard/new and push the Add new panel button.
- 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
- 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!
