Bigquery cheat sheet – Standard SQL – functions

Conversions: CAST ( expr AS type )   Aggregate functions: Return single aggregate value for group of rows ANY_VALUE ( expr) [ OVER (…) ] FROM … ARRAY_AGG( DISTINCT …. IGNORE|RESPECT NULLS ORDER BY …. LIMIT …) [ OVER () ] ARRAY_CONCAT_AGG AVG BIT_AND BIT_OR...