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 ExpressionsOfficial Docs for Reference 
  • CASE

  • COALESCE

  • NULLIF

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