Skip to main content
This gem runs in the SQL warehouse.

Overview

Limits the number of rows in the output. You can optionally skip a number of rows before the gem starts returning rows.
The Limit gem has a corresponding interactive gem example. See Interactive gem examples to learn how to run sample pipelines for this and other gems.

Parameters

Allowed values

Limit and Offset each accept one of the following:
  • A whole number, such as 100.
  • A configuration variable, such as {{ page_size }}.
  • Arithmetic on whole numbers and configuration variables using +, -, *, and parentheses, such as {{ page_size }} * 2.
Column references, functions, and CASE expressions are not supported.