what are the types can be assigned to constant in the manifest file?


I saw on the documentation that there is an option to assign constant values to variable with “constant”.

In the documentation only a string was inserted as a value.

can I use the same method to assign other types of variables? like number (of mathematical operations) or lists to it?

for example: 

I want to check if a given name is a friend of someone in my list.

constant: my_list {

value: “Oren”, “Dan”, “Nicole”


and than use it like this:

dimension : name {

type: string

SQL: ${TABLE}.name


dimension: friends {

type: yesno

SQL: case when ${name} in @my_list then yes end;;



This topic has been closed for comments