Limit input/output rows

Options
Jmoreno
Jmoreno Member
edited May 8 in Datasets

Hello,

I am wondering if there is a way to set a limit on an object coming in from workbench or limiting it in DOMO itself to "error" out if the resulting dataset will contain more than 10mil or to not allow more than 5 mil rows to be processed. These are just examples, I would like to know if there is anything of this sort in DOMO or Workbench.

Thank you

Best Answer

  • david_cunningham
    Answer ✓
    Options

    For workbench, the easiest thing to do would be to make use of the TOP/LIMIT functionality in your SQL statement.

    https://www.w3schools.com/sql/sql_top.asp

    This wouldn't cause the job to error out, but you could limit the number of rows that are processed/stored in Domo.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    Answer ✓
    Options

    For workbench, the easiest thing to do would be to make use of the TOP/LIMIT functionality in your SQL statement.

    https://www.w3schools.com/sql/sql_top.asp

    This wouldn't cause the job to error out, but you could limit the number of rows that are processed/stored in Domo.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**