Google Standard SQL (BigQuery)

VSCode

Functions

VSCode

Useful Functions not in the database function library

string_agg_distinct
count_approx

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.

date_from_unix_date
string_agg
repeat
reverse

HyperLogLog Functions

In addition to the Malloy Standard HLL Functions, BigQuery supports HLL_COUNT.MERGE, which both merges sketches and estimates cardinality.

See the BigQuery HyperLogLog Documentation.

External Resources

VSCode

• BigQuery SQL Reference