Skip to content

Quick Demo

Jump to bottom Edit New page
Aleks Volochnev edited this page Feb 21, 2021 · 15 revisions

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
  1. Launch the project
docker-compose up -d
  1. 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

  1. Load sample data

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

  1. 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!

  1. Add the panel

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

  1. 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
  1. 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!

To contact the developers, ask questions, or provide any feedback, please use Github discussions.

Clone this wiki locally