Skip to main content

Redshift function support

Table 1.

Funtion

Support

abs

Natively Supported

acos

Natively Supported

array

Unavailable

array_append

Unavailable

array_concat

Unavailable

array_contains

Unavailable

array_join

Unavailable

array_length

Unavailable

array_prepend

Unavailable

asin

Natively Supported

at_time_zone

Natively Supported

atan

Natively Supported

atan2

Natively Supported

attr_of

Emulated

ceiling

Natively Supported

char

Emulated

coalesce

Natively Supported

concat

Natively Supported

cos

Natively Supported

cosh

Emulated

current_user

Emulated

date_add

Natively Supported

date_diff

Natively Supported

date_format

Natively Supported

date_parse

Emulated

date_part

Natively Supported

date_sub

Natively Supported

date_trunc

Natively Supported

day

Natively Supported

degrees

Natively Supported

element_at

Unavailable

exp

Natively Supported

exp10

Natively Supported

floor

Natively Supported

get_path

Emulated

greatest

Natively Supported

hours

Natively Supported

iri_of

Emulated

json_extract_scalar

Emulated

label_of

Emulated

least

Natively Supported

left

Natively Supported

length

Natively Supported

like

Natively Supported

log

Natively Supported

log10

Natively Supported

lower

Natively Supported

lpad

Natively Supported

ltrim

Natively Supported

md5

Natively Supported

mid

Natively Supported

minutes

Natively Supported

mod

Natively Supported

month

Natively Supported

now

Natively Supported

pi

Natively Supported

position

Natively Supported

pow

Natively Supported

radians

Natively Supported

rand

Natively Supported

random

Natively Supported

regex

Natively Supported

regexp_extract

Emulated

replace

Natively Supported

right

Natively Supported

round

Natively Supported

rpad

Natively Supported

rtrim

Natively Supported

seconds

Natively Supported

sha1

Emulated

sha256

Emulated

sha384

Emulated

sha512

Emulated

sign

Natively Supported

sin

Natively Supported

sinh

Emulated

sqrt

Natively Supported

string_split

Emulated

substring

Natively Supported

tan

Natively Supported

tanh

Emulated

trim

Natively Supported

upper

Natively Supported

url_extract_fragment

Emulated

url_extract_host

Emulated

url_extract_parameter

Emulated

url_extract_path

Emulated

url_extract_port

Emulated

url_extract_protocol

Emulated

url_extract_query

Emulated

year

Natively Supported