Versions Compared

Key

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

In this article

Table of Contents
maxLevel2
absoluteUrltrue

Multiexcerpt include
templateData[]
MultiExcerptNameME_OE_ELT_Snap_Accounts
addpanelfalse
PageWithExcerptELT Aggregate

Overview

Use this Snap to add the ORDER BY keyword to an existing query. The ORDER BY keyword enables you to sort records in ascending or descending order of a specified column's value. Additionally, the Snap also enables you to specify whether null value records are displayed first or last. This Snap also allows you to preview the result of the output query. You can validate the modified query using this preview functionality.

Image Modified

Prerequisites

None.

Limitation

Multiexcerpt include macro
nameME_ELT_GBQ_StandardSQL_UOI
pageELT Copy

Known Issues

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

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

Document

  • Min: 1
  • Max: 1
  • ELT Select
  • ELT Copy
The SQL query in which you want to add the ORDER BY keyword.
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Unique
The incoming SQL query with the ORDER BY keyword.

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 SortSorted Employee List
Sort Paths

Required. This field set allows you to specify the sort order and placement preference for null values in each column in the table. 

Click + to add a new row. Each column for which you want to specify the sort order requires a new row.

This field set consists of the following fields:

  • Sort Path
  • Sort Order
  • Null Value Sort Preference
Sort PathStringRequired. The name of the column based on whose values you want to sort the records.N/AFNAME
Sort OrderString

Determines the order in which the values must be sorted. 

Available options are:

  • ASC: Ascending order
  • DESC: Descending order
ASCDESC
Null Value Sort PreferenceString

Determines whether the null values must be displayed first or last.

Available options are:

  • NULLS FIRST
  • NULLS LAST 
Note

This field is ignored in Azure Synapse as it does not support sorting of null values natively.


NULLS FIRSTNULLS LAST
Get preview dataCheck box
Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect
Not selectedSelected

Troubleshooting

None.

Examples

Multiexcerpt include macro
namecopyfiltersort
pageELT Copy

Download this Pipeline.

Downloads

Note
titleImportant Steps to Successfully Reuse Pipelines
  1. Download and import the Pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide Pipeline parameters as applicable.

Attachments
patterns*.slp, *.zip


Insert excerpt
ELT Snap Pack
ELT Snap Pack
nopaneltrue


See Also

SnapLogic Product Glossary