Overview

Use this Snap to add the LIMIT clause to the incoming SQL query. The LIMIT clause sets an upper limit on the number of records returned by the SQL query. Additionally, you can also specify an offset value so that the Snap displays the records from the specified offset value up to the number of records based on the specified limit. This Snap also allows you to preview the result of the output query. You can validate the modified query using this preview functionality.

Prerequisites

None.

Limitations

This Snap does not support applying an ELT Limit Offset (the value in this field is ignored) when fetching data from an Azure Synapse database.

Known Issue

Snap Input and Output

Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description

Input/Output	Type of View	Number of Views	Examples of Upstream and Downstream Snaps	Description
Input	Document	Min: 1 Max: 1	ELT Select ELT Intersect	The SQL query in which you want to add the LIMIT clause.
Output	Document	Min: 1 Max: 1	ELT Copy ELT Insert-Select	The incoming SQL query with the LIMIT clause.

Snap Settings

SQL 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 Name	Data Type	Description	Default Value	Example

Parameter Name	Data Type	Description	Default Value	Example
Label	String		ELT Limit	Top 10 Records
Get preview data	Check box		Not selected	Selected
ELT Limit	Integer	Required. The maximum number of records to be displayed.	N/A	3
ELT Limit Offset (Not valid for Azure Synapse and Databricks Lakehouse Platform)	Integer	The number of rows from the top that you want to skip. If this field is not configured, then the Snap fetches from the first row of records. For example, if you specify 2 here, then the Snap fetches records from the third row up to the number of rows specified in the ELT Limit field. This Snap does not support applying an ELT Limit Offset (the value in this field is ignored) when fetching data from an Azure Synapse or a Databricks Lakehouse Platform database.	N/A	2

Troubleshooting