Skip to main content
Version: v2.x

Row Fetch Limit

Limit the number of rows returned in a response on select operations.

You can set a row fetch limit on the Hasura Console in Data -> [table] -> Permissions -> select -> Row select permissions -> Limit number of rows as per the image below:

Row fetch limit

In the above example, this configuration restricts the number of accessible rows (based on the row permission: {"id":{"_eq":"X-Hasura-User-Id"}}) to 1.

Setting row fetch limits is useful for preventing abuse of your API especially if it is exposed to the public. You can also configure other limits.