/
SQL Expressions and Functions Supported for ELT

SQL Expressions and Functions Supported for ELT

Nov 09, 2021

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 

Supported Expressions

Official Docs for Reference 

  • CASE

  • COALESCE

  • NULLIF

Math Functions

Supported Functions    

Official Docs for Reference 

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 

Supported Functions     

Official Docs for Reference 

  • CONCAT

  • LOWER

  • LTRIM

  • REPLACE

  • REVERSE

  • RTRIM

  • SUBSTRING

  • TRANSLATE

  • TRIM

  • UPPER