ChartDataExtras

column_orderstring[]nullable

Ordered list of column names for result ordering. Used to preserve user's column reordering (including mixed dimension columns and metrics)

havingstring

HAVING clause to be added to aggregate queries using AND operator.

instant_time_comparison_rangestringnullable

This is only set using the new time comparison controls that is made available in some plugins behind the experimental feature flag.

relative_endstring

End time for relative time deltas. Default: config["DEFAULT_RELATIVE_START_TIME"]

Possible values: [today, now]

relative_startstring

Start time for relative time deltas. Default: config["DEFAULT_RELATIVE_START_TIME"]

Possible values: [today, now]

time_grain_sqlastringnullable

To what level of granularity should the temporal column be aggregated. Supports ISO 8601 durations.

Possible values: [PT1S, PT5S, PT30S, PT1M, PT5M, PT10M, PT15M, PT30M, PT1H, PT6H, P1D, P1W, P1M, P3M, P1Y, 1969-12-28T00:00:00Z/P1W, 1969-12-29T00:00:00Z/P1W, P1W/1970-01-03T00:00:00Z, P1W/1970-01-04T00:00:00Z, null]

Example: P1D

transpile_to_dialectbooleannullable

If true, WHERE/HAVING clauses will be transpiled to the target database dialect using SQLGlot.

wherestring

WHERE clause to be added to queries using AND operator.

ChartDataExtras

{
  "column_order": [
    "string"
  ],
  "having": "string",
  "instant_time_comparison_range": "string",
  "relative_end": "today",
  "relative_start": "today",
  "time_grain_sqla": "P1D",
  "transpile_to_dialect": true,
  "where": "string"
}