Types of Variables
Raw Variables
Any field in a dataset can be referenced as a variable in different components such as:
- Dataset queries
Variables in dataset queries can be manipulated by adding different suffixes as follows:
variable.raw()
: By default, the values that is pasted into queries are surrounded in quotes or formatted based on the variable type. Adding.raw()
strips away any sort of formatting. This is often required if you are using a variable as a table name, or using the variable in clauses that don’t require the value to be in quotes.
-- use a variable name in the from statement
select *
[[from tablename.{{customer.table_name.raw()}}]]