In this article
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.
ELT Snaps Vs. Standard-Mode 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 |
---|---|
|
String Functions
Supported Functions | Official Docs for Reference |
---|---|
|