Limit input/output rows

Jmoreno
Jmoreno Member
edited May 2024 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
    david_cunningham Coach
    Answer ✓

    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
    david_cunningham Coach
    Answer ✓

    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! ✔️**

Categories