What Is Malloy
Snowflake
Useful Functions not in the database function library
string_agg string_agg_distinct
Database Functions
Malloy code can, in addition to the Malloy Standard Functions, reference any of the listed functions here without needing to use Raw SQL Functions.
repeat reverse
Boolean Filter Expressions
Becase MySQL doesn't have a true boolean data type, a columns which contains boolean values will be read as numeric by Malloy. This will make it impossible to use boolean filter expressions without explicitly casting the value to type boolean
dimension: presentAndNotAccountedFor is present::boolean ~ f'true' and accountedFor::boolean ~ f'false'