Limit input/output rows

Jmoreno

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

david_cunningham

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

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.