What Is Malloy
Presto / Trino
Useful Functions not in the database function library
string_agg_distinct string_agg
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
HyperLogLog Functions
In addition to the Malloy Standard HLL Functions, Snowflake supports
HLL, which both initializes a new HLL sketch, and estimates cardinality.
See the Snowflake HyperLogLog Documentation.