> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Limit gem for Data Analysis

> Limit the number of columns processed

export const gemName_0 = "Limit"

export const execution_engine_0 = "the SQL warehouse"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

Limits the number of rows in the output.

<Tip>
  The {gemName_0} gem has a corresponding interactive gem example. See [Interactive gem
  examples](/data-analysis/gems/gems#interactive-gem-examples) to learn how to run sample pipelines
  for this and other gems.
</Tip>

### Parameters

| Parameter | Description                                                                         | Required |
| :-------- | :---------------------------------------------------------------------------------- | :------- |
| Input     | The dataset to limit.                                                               | True     |
| Limit     | Number of rows required in output. <br />**Allowed range**: \[0, 2<sup>31</sup> -1] | True     |