Snowpark Migration Accelerator: Unterstützte Funktionen

Zeichenfolgen

Funktion

Status

CONCAT

SUPPORTED

LEFT

SUPPORTED

LOWER

SUPPORTED

SPLIT

SUPPORTED

SUBSTRING

SUPPORTED

SUBSTRING_INDEX

PENDING

TRIM

SUPPORTED

UPPER

SUPPORTED

Numerik

Funktion

Status

COUNT

SUPPORTED

LAST

PENDING

MAX

SUPPORTED

MIN

SUPPORTED

ROUND

SUPPORTED

SUM

SUPPORTED

Date

Funktion

Status

CURRENT_DATE

SUPPORTED

CURRENT_TIMESTAMP

SUPPORTED

DATEDIFF

PENDING

DATE_SUB

PENDING

DAY

SUPPORTED

FIRST_VALUE

PENDING

FROM_UNIXTIME

PENDING

TO_DATE

SUPPORTED

WEEKOFYEAR

SUPPORTED

Erweiterte Funktionen

Funktion

Status

COALESCE

SUPPORTED

EXPLODE

PENDING

IFNULL

SUPPORTERD

MERGE

PENDING

POSEXPLODE

PENDING

ROW_NUMBER

SUPPORTED