Plugins 〉Sqlyze Datasource
Sqlyze Datasource
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)
| 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.
Grafana Enterprise
- Available with a Grafana Enterprise license
- Access to all Enterprise plugins
- Run fully managed or self-manage on your own infrastructure
Installing Sqlyze Datasource:
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
For more information, visit the docs on plugin installation.
Installing on a local Grafana:
For local instances, plugins are installed and updated via a simple CLI command. Plugins are not updated automatically, however you will be notified when updates are available right within your Grafana.
1. Install the Data Source
Use the grafana-cli tool to install Sqlyze Datasource from the commandline:
grafana-cli plugins install The plugin will be installed into your grafana plugins directory; the default is /var/lib/grafana/plugins. More information on the cli tool.
Alternatively, you can manually download the .zip file for your architecture below and unpack it into your grafana plugins directory.
Alternatively, you can manually download the .zip file and unpack it into your grafana plugins directory.
2. Configure the Data Source
Accessed from the Grafana main menu, newly installed data sources can be added immediately within the Data Sources section.
Next, click the Add data source button in the upper right. The data source will be available for selection in the Type select box.
To see a list of installed data sources, click the Plugins item in the main menu. Both core data sources and installed data sources will appear.
Changelog
v1.3.0 - 2023-10-30
- ⚙️ Chore: Update sqlds and sdk to capture error source
v1.2.0 - 2023-10-24
- ⚙️ Chore: Update Grafana npm dependencies to 9.5.13
v1.1.7 - 2023-10-04
- ? Fix: VariableQueryEditor - model updates without running queries
v1.1.6 - 2023-10-02
- ? Fix: VariableQueryEditor - trigger model update onblur
v1.1.5 - 2023-09-08
- ⚙️ Chore: binary compiled with newest version of the plugin-sdk which fixes bugs when dealing with float32 types
v1.1.4 - 2023-06-08
- ⚙️ Chore: backend libs updated with golang:1.20.5
v1.1.3 - 2023-06-05
- ⚙️ Chore: Backend dependencies updated
v1.1.2 - 2023-05-05
- ⚙️ Chore: Backend binaries are now compiled with Go 1.20.4
v1.1.1 - 2023-04-20
- ⚙️ Chore: Backend binaries are now compiled with Go 1.20.3
v1.1.0 - 2023-01-24
- ? Feature: include unixodbc libs in linux amd64 dist
v1.0.2 - 2022-12-21
- ⚙️ Chore: Backend binaries are now compiled with Go 1.19.4
- ⚙️ Chore: Backend Grafana dependencies updated to latest version
- ⚙️ Chore: Add spellcheck
v1.0.1 - 2022-07-11
- ? Fix: default time to UTC not Local
v1.0.0 - 2022-06-16
- ? Fix: run button position on variable page
v0.4.1 - 2022-06-09
- ? Fix: set exec permission
v0.4.0 - 2022-04-29
- ? Feature: Template variables
v0.3.0 - 2022-04-28
- ? Feature: Infer data types
v0.0.2 - 2022-04-25
- Beta release.
