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
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)
Setting | Example Value |
---|---|
Driver | /Applications/dsdriver/lib/libdb2o.dylib |
Timeout (seconds) | 10 |
host | 127.0.0.1 |
port | 50000 |
uid | db2inst1 |
pwd | •••••••••••• |
database | sample |
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.
Related resources from Grafana Labs


