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
This plugin requires an ODBC driver. ODBC Drivers are available through 3rd parties. See below for a list.
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
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)
- 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
- 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.