Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 1
  • Max: 1
  • ELT Select
  • ELT Aggregate
The SQL query to replicate.
Output

Document

  • Min: 2
  • Max: No limit
  • ELT Join
  • ELT Merge Into

Multiple copies of the input SQL query and the optional preview data (if present). 

Snap Settings

Info
titleSQL Functions and Expressions for ELT

You can use the SQL Expressions and Functions supported for ELT to define your Snap or Account settings with the Expression symbol = enabled, where available. This list is common to all target CDWs supported. You can also use other expressions/functions that your target CDW supports.


Parameter NameData TypeDescriptionDefault ValueExample 
LabelString
Insert excerpt
File Writer
File Writer
nopaneltrue
ELT CopySelect Copy

...