Redshift aggregation support

approx_distinct

Emulated

approx_median

Emulated

approx_percentile

Emulated

arbitrary

Emulated

array_agg

Unavailable

avg

Natively Supported

bool_and

Natively Supported

bool_or

Natively Supported

checksum

Emulated

correlation

Emulated

count

Natively Supported

count(*)

Natively Supported

count_if

Natively Supported

covar_pop

Emulated

covar_samp

Emulated

group_concat

Emulated

kurtosis

Emulated

max

Natively Supported

max_by

Emulated

min

Natively Supported

min_by

Emulated

regr_avgx

Emulated

regr_avgy

Emulated

regr_count

Emulated

regr_intercept

Emulated

regr_r2

Emulated

regr_slope

Emulated

regr_sxx

Emulated

regr_sxy

Emulated

regr_syy

Emulated

skewness

Emulated

std_pop

Natively Supported

std_samp

Natively Supported

stdev

Natively Supported

sum

Natively Supported

var_pop

Natively Supported

var_samp

Natively Supported

variance

Natively Supported