${TABLE} is not allowed in the 'X' property.

Knowledge Drop

Last tested: Aug 29, 2019
 

If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.

Example of where this would fail:

dimension: test {

type: string

sql: ${TABLE}.field ;;

# The below html references are incorrect. Substitution operators (the ${}) can't be used in html because they evaluate to SQL.

html: My values are ${TABLE}.field and ${otherfield ;;

}

To fix this, use liquid references instead!

dimension: test {

type: string

sql: ${TABLE}.field ;;

# {{value}} is how you reference the value of this field, and {{viewname.fieldname._value}} is how you reference the values of other fields.

html: My values are {{value}} and {{otherfield._value}} ;;

}

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 12:25 PM
Updated by: