Amazon Redshift Connectors

Back Next

Functions with Amazon Redshift V2

When you use

SQL ELT optimization

, the Secure Agent converts the expression in the transformation by determining equivalent functions in the database. If there is no equivalent function, the Secure Agent processes the transformation logic.

The following table summarizes the availability of SQL ELT functions in an Amazon Redshift database. Columns marked with an X indicate that the function can be pushed to the Amazon Redshift database. Columns marked with a dash (-) symbol indicate that the function cannot be pushed to the database.

Function	SQL ELT	Function	SQL ELT	Function	SQL ELT
ABORT()	-	INITCAP()	X	REG_MATCH()	X
ABS()	X	INSTR()	X	REG_REPLACE	X
ADD_TO_DATE()	X	IS_DATE()	-	REPLACECHR()	X
AES_DECRYPT()	-	IS_NUMBER()	X	REPLACESTR()	X
AES_ENCRYPT()	-	IS_SPACES()	X	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()	X	SINH()	-
COS()	X	LOWER()	X	SOUNDEX()	-
COSH()	-	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()	X	SYSTIMESTAMP()	X
DATE_DIFF()	X	MEDIAN()	X	TAN()	X
DECODE()	X	METAPHONE()	-	TANH()	-
DECODE_BASE64()	-	MIN()	X	TO_BIGINT	X
DECOMPRESS()	-	MOD()	X	TO_CHAR(DATE)	X
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)	X
GREATEST()	-	PV()	-	TRUNC(NUMBER)	X
IIF()	X	RAND()	-	UPPER()	X
IN()	X	RATE()	-	VARIANCE()	X
INDEXOF()	-	REG_EXTRACT()	-

Rename Saved Search

Table of Contents

Amazon Redshift Connectors

Amazon Redshift Connectors

Functions with Amazon Redshift V2

Functions with Amazon Redshift V2