Azure Synapse function support – data.world help center

Function	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	Emulated
atan	Natively Supported
atan2	Natively Supported
attr_of	Emulated
ceiling	Natively Supported
char	Natively Supported
coalesce	Natively Supported
concat	Natively Supported
cos	Natively Supported
cosh	Natively Supported
current_user	Emulated
date_add	Natively Supported
date_diff	Natively Supported
date_format	Emulated
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 (3-argument version emulated)
log	Natively Supported
log10	Natively Supported
lower	Natively Supported
lpad	Emulated
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	Emulated
regexp_extract	Emulated
replace	Natively Supported
right	Natively Supported
round	Natively Supported
rpad	Emulated
rtrim	Natively Supported
seconds	Natively Supported
sha1	Natively Supported
sha256	Natively Supported
sha384	Emulated
sha512	Natively Supported
sign	Natively Supported
sin	Natively Supported
sinh	Natively Supported
sqrt	Natively Supported
string_split	Emulated
substring	Natively Supported
tan	Natively Supported
tanh	Natively Supported
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