Queries are placed in Layer files in sections denoted with a <query>
tag. Each query tag must also be named so that it can be referred to in a pipeline step.
Example query:
<query name="myquery">
SELECT * FROM MYTABLE
</query>
In the above example, the query is named ‘myquery’ and contains inline SQL.
White Label Data supports creating multiple Personas(/docs/users-personas/personas) as well as Page Filters. Both of these create attributes (aka variables) that you can use within your SQL queries. To denote a filter or user-attribute, include the filter name or attribute name between {{
and }}
within your SQL statement. The value of these filters or attributes will get substituted with the actual value when the visualiation is rendered.