Snowflake Connector Guide

Snowflake Connector Guide

Pushdown Optimization Functions

Pushdown Optimization Functions

The following table summarizes the availability of pushdown functions in a Snowflake database. Columns marked with an X indicate that the function can be pushed to the Snowflake database by using source-side or full pushdown optimization. Columns marked with a dash (-) symbol indicate that the function cannot be pushed to the database.
Function Pushdown Function Pushdown Function Pushdown
ABORT() - INITCAP() X REG_MATCH() -
ABS() X INSTR() X REG_REPLACE -
ADD_TO_DATE() X IS_DATE() - REPLACECHR() X
AES_DECRYPT() - IS_NUMBER() - REPLACESTR() X
AES_ENCRYPT() - IS_SPACES() - REVERSE() -
ASCII() X ISNULL() X ROUND(DATE) -
AVG() X LAST() - ROUND(NUMBER) X
CEIL() X LAST_DAY() X RPAD() X
CHOOSE() - LEAST() - RTRIM() X
CHR() X LENGTH() X SET_DATE_PART() -
CHRCODE() - LN() X SIGN() X
COMPRESS() - LOG() X SIN() X
CONCAT() X LOOKUP - SINH() X
COS() X LOWER() X SOUNDEX() -
COSH() X LPAD() X SQRT() X
COUNT() X LTRIM() X STDDEV() X
CRC32() - MAKE_DATE_TIME() - SUBSTR() X
CUME() - MAX() X SUM() X
DATE_COMPARE() X MD5() - SYSDATE() X
DATE_DIFF() X MEDIAN() X SYSTIMESTAMP() X
DECODE() X METAPHONE() - TAN() X
DECODE_BASE64() - MIN() X TANH() X
DECOMPRESS() - MOD() X TO_BIGINT X
ENCODE_BASE64() - MOVINGAVG() - TO_CHAR(DATE) X
EXP() X MOVINGSUM() - TO_CHAR(NUMBER) X
FIRST() - NPER() - TO_DATE() X
FLOOR() X PERCENTILE() - TO_DECIMAL() X
FV() - PMT() - TO_FLOAT() X
GET_DATE_PART() X POWER() X TO_INTEGER() X
GREATEST() - PV() - TRUNC(DATE) -
IIF() X RAND() - TRUNC(NUMBER) X
IN() X RATE() - UPPER() X
INDEXOF() - REG_EXTRACT() - VARIANCE() X
The following table lists the pushdown operators that can be used in a Snowflake database:
Operator Pushdown
+ Supported
- Supported
* Supported
/ Supported
% Supported
|| Supported
> Supported
= Supported
>= Supported
<= Supported
!= Supported
AND Supported
OR Supported
NOT Supported
^= Supported

Updated August 12, 2019


Explore Informatica Network