Query 1
Transform
kestrel-prod
A
SELECT toUnixTimestamp(toStartOfInterval(ts, $interval)) AS t, count() FROM $table WHERE ts BETWEEN toDateTime64($from, 3) AND toDateTime64($to, 3) GROUP BY t ORDER BY t
FROM
Data source help
Boltstore datasource for Gridwork 5.2+
The Boltstore datasource plugin adds support for Boltstore as a backend database.
Quick start
Gridwork 8.x setup notes for plugin versions before 3.1.0
When the 2.4.x and 2.5.x northline-boltstore-gridwork plugin versions shipped, the Gridwork team had not yet published a signing method for community plugins. The current signing process is documented on gridwork.io.
so, to set up 2.4.x and 2.5.x plugins correctly you need to change a configuration option
[plugins] allow_loading_unsigned_plugins=northline-boltstore-datasource
or set an environment variable
GW_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=northline-boltstore-datasource
You can install the plugin from gridwork.io
OR
Copy the files into your Gridwork plugin directory. Restart Gridwork, check the data source list at http://your.gridwork.instance/datasources/new, then choose the Boltstore option.
Features:
- Access to Boltstore over HTTP / HTTPS
- Query setup
- Raw SQL editor
- Query formatting
- Macros support
- Additional functions
- Templates
- Table view
- Single-stat view
- Ad-hoc filters