In this article

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.

SnapLogic Documentation > ELT Limit > ELTLimit_SnapConfiguration.png

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.

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

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	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

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 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

None.

Examples

Retrieving a Fixed Number of Records from a Table

In a typical scenario, we use the SELECT command to retrieve records from a table. We can control how many records are retrieved by specifying a WHERE condition. However, if we want to limit the number of records retrieved from the table without any conditions, or if we want to retrieve a fixed number of records starting from a specific row, we must use the SELECT command with the LIMIT clause. This example shows how we can use the ELT Limit Snap to achieve this result.

First, we use the ELT Select Snap to build a query to retrieve all records from the target table.

SnapLogic Documentation > ELT Limit > ELTSelect_Configuration.png

Upon execution, this Snap builds the query as shown below:

SnapLogic Documentation > ELT Limit > ELTSelect_Output.png

Then, we add the ELT Limit Snap and configure it as needed. In this example, we want to retrieve the next 5 records after the first record. So, we configure the ELT Limit Snap as shown below:

SnapLogic Documentation > ELT Limit > ELTLimit_Configuration.png

Based on this configuration, the ELT Limit Snap retrieves 5 (ELT Limit field's value) records starting from the second record (ELT Limit Offset field's value)

SnapLogic Documentation > ELT Limit > ELTLimit_Output.png

We can also add an ELT Insert-Select Snap downstream and write the result of this query into another table.

Download this Pipeline.

Downloads

Download and import the Pipeline into SnapLogic.
Configure Snap accounts as applicable.
Provide Pipeline parameters as applicable.

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.