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.
<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
}} within your SQL statement. The value of these filters or attributes will get substituted with the actual value when the visualiation is rendered.