...
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
...
| 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 OffsetOffset (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.
| N/A | 2 | Get preview data | Check box |
| Not selected | Selected |
Troubleshooting
None.
Examples
...