row limit of 5000000 exceeded

[noopurjain]

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.  

[apathetichell]

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.

[danilang]

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    

[Qiu]

@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