Functions# Aggregate Aggregate AVG CORR 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 Bitwise BIT_AND BIT_COUNT BIT_NOT BIT_OR BIT_XOR Conditional Conditional CASE 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 TRUNC String String BIT_LENGTH CONCAT CONCAT_WS DATE ENDS_WITH INITCAP LEFT LENGTH LOWER LPAD LTRIM NORMALIZE OCTET_LENGTH POSITION REGEXP_LIKE REPLACE REVERSE RIGHT RPAD RTRIM SPLIT_PART STARTS_WITH STRING_TO_ARRAY STRPOS STRPTIME SUBSTR SUBSTRING TIMESTAMP TRIM 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 Window Window DENSE_RANK FIRST_VALUE LAG LAST_VALUE LEAD RANK ROW_NUMBER OVER