Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/trinodb/grafana-trino below:

trinodb/grafana-trino: The Trino datasource allows to query and visualize Trino data from within Grafana.

The Trino datasource allows to query and visualize Trino data from within Grafana.

Drop this into Grafana's plugins directory. To run it locally without installing Grafana, run it in a Docker container using:

docker run -d -p 3000:3000 \
  -v "$(pwd):/var/lib/grafana/plugins/trino" \
  -e "GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=trino-datasource" \
  --name=grafana \
  grafana/grafana-oss

• Authentication:
  • HTTP Basic
  • TLS client authentication
  • Access token (JWT)
  • OAuth
• Raw SQL editor only, no query builder yet
• Macros

Plugin supports the following marcos:

• $timeFrom($column) - replaced with the lower boundary of the currently selected "Time Range" as a timestamp.
• $timeTo($column) - replaced with the upper boundary of the currently selected "Time Range" as a timestamp.
• $timeGroup($column, $interval) - replaced with an expression that rounds values of a column to the selected "Group by a time interval" value.
• $dateFilter($column) - replaced with a range condition for the currently selected "Time Range" as dates, on a column passed as the $column argument. Use it in queries or query variables as ...WHERE $dateFilter($column)... or ...WHERE $dateFilter(created_at).....
• $timeFilter($column) - replaced with a range condition for the currently selected "Time Range" as timestamps, on a column passed as the $column argument.
• $unixEpochFilter($column) - replaced with a range condition for the currently selected "Time Range", on a column passed as the $column argument.
• $parseTime - parse a timestamp string using the default or specified format.

A description of macros is available by typing their names in Raw Editor

Template variable values are only quoted when the template variable is a multi-value.

If the variable is a multi-value variable then use the IN comparison operator rather than = to match against multiple values.

Example with a template variable named hostname:

SELECT
  atimestamp as time,
  aint as value
FROM table
WHERE $__timeFilter(atimestamp) and hostname in($hostname)
ORDER BY atimestamp ASC

Grafana automatically creates a quoted, comma-separated string for multi-value variables. For example: if server01 and server02 are selected then it will be formatted as: 'server01', 'server02'. To disable quoting, use the csv formatting option for variables:

Read more about variable formatting options in the Variables documentation.

If you have any idea for an improvement or found a bug do not hesitate to open an issue or submit a pull request. We will appreciate any help from the community.

See DEVELOPMENT.md for development instructions.

Apache 2.0 License, please see LICENSE for details.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4