Skip to main content

Reference Operator ($)

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

Using in View

References can be used in derived_table parameter of current View:

${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 current View:

${field_name} - references another Field declared in Fields section of current 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.