Plugins 〉Sqlyze Datasource

Data Source
grafana
Enterprise

Sqlyze Datasource

  • Overview
  • Installation
  • Change log
  • Related content

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 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)

SettingExample Value
Driver/Applications/dsdriver/lib/libdb2o.dylib
Timeout (seconds)10
host127.0.0.1
port50000
uiddb2inst1
pwd••••••••••••
databasesample

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.

Installing Sqlyze Datasource:

For more information, visit the docs on plugin installation.

Changelog

1.0.1

Fix - default time to UTC not Local

1.0.0

Fix - run button position on variable page

0.4.1

Fix - set exec permission

0.4.0

Feature - Template variables

0.3.0

Feature - Infer data types

0.0.2

Beta release.