Snowpark Migration Accelerator : Fonctions prises en charge¶
Chaînes¶
Fonction |
Statut |
|---|---|
CONCAT |
SUPPORTED |
LEFT |
SUPPORTED |
LOWER |
SUPPORTED |
SPLIT |
SUPPORTED |
SUBSTRING |
SUPPORTED |
SUBSTRING_INDEX |
PENDING |
TRIM |
SUPPORTED |
UPPER |
SUPPORTED |
Valeurs numériques¶
Fonction |
Statut |
|---|---|
COUNT |
SUPPORTED |
LAST |
PENDING |
MAX |
SUPPORTED |
MIN |
SUPPORTED |
ROUND |
SUPPORTED |
SUM |
SUPPORTED |
Date¶
Fonction |
Statut |
|---|---|
CURRENT_DATE |
SUPPORTED |
CURRENT_TIMESTAMP |
SUPPORTED |
DATEDIFF |
PENDING |
DATE_SUB |
PENDING |
DAY |
SUPPORTED |
FIRST_VALUE |
PENDING |
FROM_UNIXTIME |
PENDING |
TO_DATE |
SUPPORTED |
WEEKOFYEAR |
SUPPORTED |
Fonctions avancées¶
Fonction |
Statut |
|---|---|
COALESCE |
SUPPORTED |
EXPLODE |
PENDING |
IFNULL |
SUPPORTERD |
MERGE |
PENDING |
POSEXPLODE |
PENDING |
ROW_NUMBER |
SUPPORTED |