How to remove the 1000 row limit from Aginity Workbench

To remove the 1000 row limit of your query set, simply visit the Tools -> Options menu and click on the result set options.  You can change the default to another number or use 0 to include all rows.

Have more questions? Submit a request


  • 0
    vineet paladi

    Great Help!!!my team was looking for this since months.

  • 0

    Hi I'm having now row limit problem though I tried this above solution.

    I can't set a number over than 100,000.

    For example, I tried to input 1,000, 000 in this row limit window, but it changed my input into 100,000 automatically.

    Also I tried to push the up arrow button next to input column, but it did not work counting more than 100,000.

    This column refusing more than 100, 000.


  • 0
    Sri Sivani Charan Yalamanchi

    I have had the same issue. I could not set the limit more than 100,000. Is there a way to increase the limit beyond 100,000?

  • 0
    Elena Knetl

    The maximum limit is 100,000, if you put in 0 that makes it unlimited.

Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk