Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Supported functions and operators for Amazon Redshift mappings

Supported functions and operators for Amazon Redshift mappings

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