Parameters allow you to implement variables in certain parts of your Query. This is useful if you want to create a Query that you can reuse with different parameters.
{{example_parameter_name}}
cast
function.
unnest
and split
functions to turn the columns into useable values.
By default, the values will be inserted into the query as individual columns.
Example:example_parameter_name
will be inserted into the query like this:
where in
clause. To do this, you need to use the unnest
and split
functions to turn the columns into useable values.
For example:
cast
function.
A very common example of using a manual list is setting the “time granularity” of a dashboard/query.
{{example_parameter_name}}
syntax