Grafana Sqlyze Data source

A Grafana data source plugin that connects to hundreds of datasources using one language: SQL. Connect to your favorite SQL databases, NoSQL databases, and many other non-SQL sources…and query them with SQL.

This plugin is not yet supported in Grafana Cloud.

The data source uses ODBC

This plugin has a dependency on ODBC. Windows/Linux/MacOS all support ODBC. Some dependencies may need to be installed.

Using ODBC with Linux ARM or MacOS

Install or make sure unixODBC is installed

https://www.ibm.com/docs/en/db2/11.5?topic=managers-installing-unixodbc-driver-manager

This plugin requires an ODBC driver. ODBC Drivers are available through 3rd parties. See below for a list.

Time series

To format your queries for time series, simply use the alias: as time

sql

select date_start as time, foo, avg(bar) as bar
from foo_bar

Short list of known drivers and settings

DB2

• Can be downloaded from IBM Fix Central where you can choose your DB2 Version and Platform: https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.5.*&platform=Mac+OSX&function=all

• Driver Settings - set the path to where the driver is installed and add required settings (MacOS example below)

Impala

• Driver: https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-14.html
• Settings: https://docs.cloudera.com/documentation/other/connectors/impala-odbc/latest/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf

Databricks

• Driver: https://databricks.com/spark/odbc-drivers-download
• Settings: https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html#odbc-driver

Third party drivers

Settings vary per driver. This plugin allows any key/value pair to support various ODBC drivers.