Trino Time Series Query Go SDK
Constructor#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
var options []timeseries.Option
timeseries.TrinoTimeSeriesQuery("SELECT date_trunc('minute', event_time) AS time, count(*) AS events FROM events GROUP BY 1 ORDER BY 1", options...)Need to provide the SQL query expression and a list of options.
Default options#
- Query(): with the expression provided in the constructor.
Available options#
Query#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.Query("SELECT date_trunc('minute', event_time) AS time, count(*) AS events FROM events GROUP BY 1 ORDER BY 1")Define the SQL query expression.
Datasource#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.Datasource("MyTrinoDatasource")Define the datasource the query will use.
Catalog and Schema#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.Catalog("iceberg")
timeseries.Schema("analytics")Set the catalog and schema sent as X-Trino-Catalog and X-Trino-Schema.
Session Properties#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.SessionProperties("query_max_run_time=5m")Set name=value session properties, separated by commas or line breaks, sent as X-Trino-Session.
Source#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.Source("perses")Set the source label sent as X-Trino-Source.
Routing Group#
import timeseries "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries.RoutingGroup("adhoc")Set the routing group sent as X-Trino-Routing-Group, used by Trino Gateway.
Example#
package main
import (
"github.com/perses/perses/go-sdk/dashboard"
"github.com/perses/perses/go-sdk/panel"
panelgroup "github.com/perses/perses/go-sdk/panel-group"
trinoquery "github.com/perses/plugins/trino/sdk/go/query/time-series"
timeseries "github.com/perses/plugins/timeserieschart/sdk/go"
)
func main() {
dashboard.New("Trino Dashboard",
dashboard.AddPanelGroup("Metrics",
panelgroup.AddPanel("Events per minute",
timeseries.Chart(),
panel.AddQuery(
trinoquery.TrinoTimeSeriesQuery(`
SELECT
date_trunc('minute', event_time) AS time,
count(*) AS events
FROM events
WHERE event_time BETWEEN TIMESTAMP '{start}' AND TIMESTAMP '{end}'
GROUP BY 1
ORDER BY 1
`, trinoquery.Catalog("iceberg"), trinoquery.Schema("analytics")),
),
),
),
)
}
