Time variables
The time range you select on your dashboard is automatically available as {{time}}
, {{start_time}}
, and {{end_time}}
variables in your queries.
Insert selected source, current time range, and other custom values into your SQL queries to customize your charts.
Type {{variable_name}}
to use existing or create new variables in your queries.
Variables are either required or optional:
Required variables are necessary for the SQL query to run. If not provided, an error will be raised. They are denoted using the double curly braces: {{variable_name}}
.
Optional variables are denoted by double square brackets enclosing a block that contains a variable: [[ ... {{variable_name}} ... ]]
. If the variable inside the optional block is not provided, the whole block is removed from the query.
SELECT {{time}} AS time,
countMerge(rows) as count
FROM {{source}}
WHERE time BETWEEN {{start_time}} AND {{end_time}}
AND request_user_agent ILIKE '%' || {{user_agent}} || '%'
[[ AND level = {{log_level}} ]]
GROUP BY time
In this code block, {{time}}
, {{source}}
, and {{user_agent}}
are required variables, while {{log_level}}
is an optional variable. The SQL query will still run if no value is selected for {{log_level}}
, but it will further filter the results if it is specified.
The time range you select on your dashboard is automatically available as {{time}}
, {{start_time}}
, and {{end_time}}
variables in your queries.
You can use {{source:source_id}}
to access your sources directly without selecting them in source select.
Find ID for you source in: Sources → Configure
Please let us know at hello@betterstack.com.
We're happy to help! 🙏