Forming Queries

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.

Using Filters and User Attributes and Queries

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.

Query Rendering