SQL Functions# Aggregate Aggregate AVG COUNT FIRST LAST MAX MEDIAN MIN QUANTILE_CONT QUANTILE_DISC STDDEV SUM VARIANCE Array Array ARRAY_AGG ARRAY_CONTAINS ARRAY_GET ARRAY_LENGTH ARRAY_LOWER ARRAY_MEAN ARRAY_REVERSE ARRAY_SUM ARRAY_TO_STRING ARRAY_UNIQUE ARRAY_UPPER UNNEST Bitwise Temporal BIT_AND BIT_COUNT BIT_OR BIT_XOR Conditional Conditional COALESCE GREATEST IF IFNULL LEAST NULLIF Mathematical Math ABS CBRT CEIL DIV EXP FLOOR LN LOG LOG2 LOG10 LOG1P MOD PI POW ROUND SIGN SQRT String String BIT_LENGTH CONCAT CONCAT_WS DATE ENDS_WITH INITCAP LEFT LENGTH LOWER LTRIM OCTET_LENGTH REGEXP_LIKE REPLACE REVERSE RIGHT RTRIM STARTS_WITH STRPOS STRPTIME SUBSTR TIMESTAMP UPPER Temporal Temporal DATE_PART EXTRACT STRFTIME Trigonometry Trigonometry ACOS ACOSD ASIN ASIND ATAN ATAND ATAN2 ATAN2D COT COTD COS COSD DEGREES RADIANS SIN SIND TAN TAND Types Types CAST TRY_CAST
