|Input/Output||Type of View||Number of Views||Examples of Upstream and Downstream Snaps||Description|
|The SQL query in which you want to add the LIMIT clause.|
The incoming SQL query with the LIMIT clause.
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|
|ELT Limit||Top 10 Records|
|Get preview data||Check box|
|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.