Setting up a Redash Instances

Go to Homepage of Redash.

Install GridDB Plugin

1. Put file griddb.png into $REDASH_SETUP_FOLDER/client/app/assets/images/db-logos

2. Put file griddb.py into $REDASH_SETUP_FOLDER/redash/query_runner

3. Modify file $REDASH_SETUP_FOLDER/redash/settings/__init__.py as below:

default_query_runners = [
  'redash.query_runner.athena',
  'redash.query_runner.big_query',
  ........
  'redash.query_runner.uptycs',
  'redash.query_runner.griddb'      --> Add this line
]

To apply new datasource plugin, go to $REDASH_SETUP_FOLDER:

npm run build
docker-compose build worker
docker-compose build server
docker-compose up

Create dashboard with GridDB

Set up a new datasource (GridDB)

Figure 1: Add datasource

From list of datasource, choose GridDB

Figure 2: Add datasource

Field	Description
Name	Name of GridDB datasource
Host	IP address of WebAPI
Port	Port of WebAPI
Cluster	Cluster name
Database	Database name. Input only "public"
Username	User name of GridDB
Password	Password of GridDB

• Click Save to save datasource
• Click Test connection to test the connection to datasource

Create query for GridDB

From main menu, click Create/Query to create a new query

Figure 3: Create query

• GridDB Plugin supports SQL Select as queries
• GridDB Plugin supports auto-complete for queries
• Once a query is saved, it should be published to visualize in dashboard

Create dashboard

From main menu, click Create/Dashboard to create a new dashboard

Click Add widget to add a Visualization with data obtained from a Query for Dashboard

Figure 4: Add widget for dashboard

Click Add to dashboard, data will be displayed (with many types of visualizations)

Figure 5: Add widget for dashboard