SQL variables

Reference variables that template the SQL in your models and make it reusable

${field} - reference a field in the current model
${model.field} - reference a field in another model
${TABLE} - reference the current table's sql reference
${qyra.attributes.my_attr_1} - a user attribute called my_attr_1
- (optional) ld as an alias for qyra
- (optional) attribute or attr as an alias for attributes
${"{"{"}"}qyra.user.<intrinsic_attribute>{"}"} - reference an intrinsic_attribute of the current Qyra user
- (optional) ld as an alias for qyra
- available intrinsic user attributes:
  - email

The user email attribute is only available when the email is verified.

This is a security measure to prevent users from creating/updating an account with any email they don't own and gain access to data they shouldn't see.

If the user email is not verified you will get the following error:

Red error toast reading "Error running query: missing user attribute email on sql_filter"

models:
  - name: example
    meta:
      sql_filter: ${qyra.user.email} = 'example@qyraflow.com'

If you are self hosting you can enable SMTP or SSO authentication to allow users to verify their email address.

How to use parameters

Parameters are variables users set at runtime to build dynamic, reusable queries without writing SQL

Virtual views

Turn a custom SQL query into a reusable table you can explore, join, and manage as code

Semantic layer