ODBC Connector > Pushdown optimization > Pushdown optimization functions
  

Pushdown optimization functions

When you enable pushdown optimization, the Secure Agent converts the expression in the transformation by determining equivalent functions in the database. If there is no function in the database, the Secure Agent processes the transformation logic.
The following table summarizes the pushdown optimization type for the available pushdown functions for supported databases:
Functions
Amazon Redshift
Google BigQuery
Microsoft Azure SQL Data Warehouse
Netezza
PostgreSQL
Snowflake
Teradata
ABS()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
ADD_TO_DATE()
Source, Full
Source, Full
Source, Full
-
-
Source, Full
-
ASCII()
-
-
Source, Full
-
Source, Full
Source, Full
-
AVG()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
CEIL()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
CHR()
Source, Full
-
Source, Full
-
Source, Full
Source, Full
-
CONCAT()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
COS()
Source, Full
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
COSH()
-
-
-
-
-
Source, Full
-
COUNT()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
DATE_COMPARE()
Source, Full
Source, Full
-
Source, Full
-
Source, Full
Source, Full
DATE_DIFF()
Source, Full
-
Source, Full
-
-
Source, Full
-
DECODE()
Source, Full
-
Source, Full
Source, Full
-
Source, Full
Source, Full
EXP()
Source, Full
-
Source, Full
Source, Full
-
Source, Full
Source, Full
FIRST()
-
-
Source, Full
-
-
-
-
FLOOR()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
GET_DATE_PART()
Source, Full
Source, Full
Source, Full
-
-
Source, Full
-
IIF()
Source, Full
-
Source, Full
Source, Full
-
Source, Full
Source, Full
IN()
Source, Full
-
-
Source, Full
-
-
Source, Full
INITCAP()
Source, Full
-
-
-
-
Source, Full
-
INSTR()
Source, Full
Source, Full
Source, Full
-
-
Source, Full
-
ISNULL()
Source, Full
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
LAST()
-
-
Source, Full
-
-
-
-
LAST_DAY()
Source, Full
Source, Full
-
-
-
Source, Full
-
LENGTH()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
LN()
Source, Full
-
-
-
-
Source, Full
-
LOG()
-
-
Source, Full
-
-
Source, Full
-
LOWER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
LPAD()
Source, Full
-
-
-
Source, Full
Source, Full
-
LTRIM()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
MAKE_DATE_TIME()
-
-
Source, Full
-
-
-
-
MAX()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
MAX(NUMBER,DATE,STRING)
-
-
-
-
-
-
-
MIN(NUMBER,DATE,STRING)
-
-
-
-
-
-
-
MEDIAN()
-
-
-
-
-
Source, Full
-
MIN()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
MD5()
Source, Full
-
Source, Full
-
-
Source, Full
-
MOD()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
POWER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
REPLACECHR()
-
Source, Full
Source, Full
-
-
-
-
REPLACESTR()
-
Source, Full
Source, Full
-
-
Source, Full
-
ROUND(NUMBER)
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
RPAD()
Source, Full
-
-
-
Source, Full
Source, Full
-
RTRIM()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
SET_DATE_PART()
-
-
Source, Full
-
-
-
-
SIGN()
Source, Full
-
Source, Full
-
-
Source, Full
-
SIN()
Source, Full
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
SINH()
-
-
Source, Full
-
-
Source, Full
-
SOUNDEX()
-
-
Source, Full
-
-
-
-
SQRT()
Source, Full
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
STDDEV()
Source, Full
-
Source, Full
-
-
Source, Full
-
SUBSTR()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
SUM()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
SYSDATE()
-
Source, Full
Source, Full
-
-
-
-
SYSTIMESTAMP()
Source, Full
Source, Full
Source, Full
-
Source, Full
-
-
TAN()
Source, Full
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
TANH()
-
-
Source, Full
-
-
Source, Full
-
TO_BIGINT
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
TO_CHAR(DATE)
Source, Full
Source, Full
Source, Full
-
Source, Full
-
-
TO_CHAR(NUMBER)
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
TO_DATE()
Source, Full
Source, Full
Source, Full
-
Source, Full
Source, Full
-
TO_DECIMAL()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
-
TO_FLOAT()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
-
TO_INTEGER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
-
TO_NUMBER()
-
-
-
-
-
Source, Full
-
TRUNC(DATE)
Source, Full
Source, Full
-
-
-
Source, Full
-
TRUNC(NUMBER)
Source, Full
Source, Full
Source, Full
-
-
Source, Full
-
UPPER()
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
Source, Full
VARIANCE()
Source, Full
-
Source, Full
-
-
Source, Full
-