Hi,
Is there a way to connect to the data lakehouse platform Dremio from Grafana, I do not see any available datasource ?
Thanks
Maybe use its rest api. That is another wwy to connect
Yup - could use the REST API with one of the the JSON datasources Grafana Plugins - extend and customize your Grafana | Grafana Labs such as Infinity, or maybe one of the SQL datasources with SQL Reference | Dremio Documentation
@davidharris - the SQL reference documents accessing the Dremio data using SQL queries, not much whether it can be connected as a SQL data source from Grafana. Do you know if it is feasible?
@yosiasz - yes connecting as a JSON API may be feasible, trade-off being having to write REST API endpoint calls using JSONata or JSONPath instead of simple SQL queries for the dashboards.
All,
On the same note, is it possible to install a Dremio driver in Grafana servers and connect to Dremio from Grafana using JDBC / ODBC, for example?
Thanks
agreed
or use infinity plugin with simple parse-json and jsonata
You can use the Sqlyze datasource with the Flight SQL ODBC Driver.
@jeeshandas
Hello Sir, do you connect to dremio successfully? thanks.
It seems like there should be a simple way to do this.
yes there is. infinity plugin using rest api.
I have used the REST API for Dremio to query from a node.js application using Kysely. When building the Kysely driver, I had to be aware of one main limitation of Dremio… from the REST API, you can only get 500 records per response to each request. You have to continue to send the same query with different limit and offset values shifted up by 500 until the response does not have 500 records.