SQL Expressions and Functions Supported for ELT
In this article
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.
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.
- 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 |
---|---|
|
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.