Skip to main content

Reference Operator ${ ... }

BlockML reference operator ($) helps to reuse existing views and fields

Using in View

References can be used in table parameter of View:

${env.ENVIRONMENT_VARIABLE_NAME} - references Variable of Environment selected in UI.

References can be used in derived_table parameter of View:

${env.ENVIRONMENT_VARIABLE_NAME} - references Variable of Environment selected in UI.

${view_name AS as_name} - references another View.

${as_name.field_name} - references Field from another View.

References can be used in sql_ parameters of View:

${field_name} - references another Field declared in Fields section in the same View.

Using in Model

References can be used in sql_ parameters of current Model:

${field_name} - references another Field declared in Fields section of current Model.

${alias_name.field_name} - references another Field from joined View.