Date and Time functions
YEAR, QUARTER, MONTH, WEEK, WEEKOFYEAR, DAY, DAYOFMONTH, HOUR, MINUTE, SECOND, DATEDIFF, DATE_ADD, DATE_SUB, FROM_UTC_TIMESTAMP, TO_UTC_TIMESTAMP, TO_DATE
Conversion functions
SN
Math functions
ABS, ACOS, ASIN, ATAN, BIN, CEIL, CEILING, CONV, COS, DEGREES, E, EXP, FLOOR, HEX, LN, LOG, LOG10, LOG2, NEGATIVE, PI, POW, POWER, POSITIVE, PMOD, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, TAN
Operators
%, -, +, *, /
Statistical functions
SUM, AVG, MIN, MAX, COUNT, UNIQUECOUNT, VARIANCE, VAR_POP, VAR_SAMP, STDDEV_POP, STDDEV_SAMP, CORR, COVAR_POP, COVAR_SAMP, PERCENTILE
Text functions
ASCII, CONCAT, CONCAT_WS, INSTR, FIND_IN_SET, GET_JSON_OBJECT, IN_FILE, INSTR, LENGTH, LOWER, LCASE, LPAD, LTRIM, RPAD, RTRIM, TRIM, UPPER, LOCATE, REPEAT, SPACE, REGEXP_REPLACE, REGEXP_EXTRACT, SUBSTR, SUBSTRING, REVERSE, TRANSLATE, PARSE_URL, UCASE
Non-supported functions
Statistical functions:
HISTOGRAM_NUMERIC, COLLECT_SET, COLLECT_LIST
Date and Time functions:
FROM_UNIXTIME, UNIXTIMESTAMP
Text Functions:
BASE64, CONTEXT_NGRAMS, DECODE, ENCODE, NGRAMS, PRINTF, SENTENCES, SPLIT, STR_TO_MAP, UNBASE64, FORMAT_NUMBER
Collection Functions, Type Conversion Functions, Conditional Functions, Misc. Functions and Table-Generating Functions are not supported in this version of the connector.
Binning is not supported by this connector.