GreptimeDB Time Series Query Go SDK

Constructor

import "github.com/perses/plugins/greptimedb/sdk/go/query/time-series"

var options []timeseries.Option
timeseries.GreptimeDBTimeSeriesQuery(`
  SELECT time_window, loc,
      max(max_temp) RANGE '1m' FILL LINEAR AS max_temp
    FROM public.temp_alerts
    WHERE time_window >= to_timestamp_millis(${__from})
      AND time_window <= to_timestamp_millis(${__to})
    ALIGN '30s' BY (loc)
    ORDER BY time_window ASC
    LIMIT 2000
`, 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 "github.com/perses/plugins/greptimedb/sdk/go/query/time-series"

timeseries.Query(`
  SELECT time_window, loc,
      max(max_temp) RANGE '1m' FILL LINEAR AS max_temp
    FROM public.temp_alerts
    WHERE time_window >= to_timestamp_millis(${__from})
      AND time_window <= to_timestamp_millis(${__to})
    ALIGN '30s' BY (loc)
    ORDER BY time_window ASC
    LIMIT 2000
`)

Define the SQL query expression. ${__from} and ${__to} are replaced when the dashboard runs in Perses.

Datasource

import "github.com/perses/plugins/greptimedb/sdk/go/query/time-series"

timeseries.Datasource("MyGreptimeDBDatasource")

Define the datasource the query will use.

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"
    "github.com/perses/plugins/greptimedb/sdk/go/query/time-series"
    tsChart "github.com/perses/plugins/timeserieschart/sdk/go"
)

func main() {
    dashboard.New("GreptimeDB Dashboard",
        dashboard.AddPanelGroup("Metrics",
            panelgroup.AddPanel("Max temperature",
                tsChart.Chart(),
                panel.AddQuery(
                    timeseries.GreptimeDBTimeSeriesQuery(`
                        SELECT time_window, loc,
                            max(max_temp) RANGE '1m' FILL LINEAR AS max_temp
                          FROM public.temp_alerts
                          WHERE time_window >= to_timestamp_millis(${__from})
                            AND time_window <= to_timestamp_millis(${__to})
                          ALIGN '30s' BY (loc)
                          ORDER BY time_window ASC
                          LIMIT 2000
                    `),
                ),
            ),
        ),
    )
}