...
Overview
You can use the following expressions with the Expression symbol = enabled, where available, to define the field values in ELT Snaps and accounts. In addition to the list provided below, you can always use the scalar value SQL functions and expressions that your target cloud data warehouse (CDW) supports.
| Warning |
|---|
| title | ELT Snaps Vs. Standard-Mode Snaps |
|---|
|
In the ELT Snaps: - Do not use regular JavaScript expressions (supported in the Standard-mode Snaps) that are not listed here.
- Do not prefix the variable names with $ symbol.
|
Conditional Expressions
| Supported Expressions | Official Docs for Reference |
|---|
| |
Math Functions
| Supported Functions | Official Docs for Reference |
|---|
ABS ACOS ASIN ATAN ATAN2 COS EXP FLOOR LOG POWER ROUND SIN SIGN SQRT TAN
| |
String Functions
| Supported Functions | Official Docs for Reference |
|---|
CONCAT LOWER LTRIM REPLACE REVERSE RTRIM SUBSTRING TRANSLATE TRIM UPPER
| |
...
