In this article
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.
Provide a functional overview of the Snap. Do not mention anything about the Snap's internal technology or techniques. The user should be able to understand what the Snap. Include a screenshot of a well-configured Snap 600px.
None.
Type of view: Document/Binary/Both. Get number of views from the Views tab in the Snap. List at least three compatible Snaps in each category. Provide a brief of the input/output required. If the input/output is optional then preface the description with "Optional." For example, "Transaction data complying with the Orderful schema as a JSON document."
Input/Output | Type of View | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| The SQL query in which you want to add the ORDER BY keyword. |
Output | Document |
|
| The incoming SQL query with the ORDER BY keyword. |
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 Name | Data Type | Description | Default Value | Example | |
---|---|---|---|---|---|
Label | String | ELT Sort | Sorted 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 | String | Required. The name of the column based on whose values you want to sort the records. | N/A | FNAME | |
Sort Order | String | Determines the order in which the values must be sorted. Available options are:
| ASC | DESC | |
Null Value Sort Preference | String | Determines whether the null values must be displayed first or last. Available options are:
| NULLS FIRST | NULLS LAST | |
Get preview data | Check box | Not selected | Selected |
None.
|
Edit the Excerpt Include macro below to link to the Snap Pack page for this Snap page. Ensure that the heading Snap Pack History is not within the Snap Pack's history Excerpt.