Skip to end of banner
Go to start of banner

SQL Expressions and Functions Supported for ELT

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

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.
  • Do not 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

  • No labels

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.