I am getting below error while executing an Alteryx flow.
" Error SQLExecute: ERROR: WLM row limit of 5000000 exceeded; Error while executing the query"
My Alteryx application is directly connected to the database.
Is this In-DB or through an Input tool - what kind of DB - this looks like a setting in your ODBC as I know Alteryx doesn't have a 5,000,000 row limit.
Hi @noopurjain
This is a non-superuser row limit imposed in systems like Yellowbrick. You can get around it by putting your output tool in a batch macro and setting it up so each iteration of the macro only writes 5M rows.
Dan
@noopurjain
I followed the comment of @danilang , if your DB is YellowBrick, you can ask your administrator to uplift the row limit.
https://www.yellowbrick.com/docs/4.0/workload/wlm_rule_actions.html