community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Input Data tool Queries should not lock the database

When users execute a sql statement via an input tool, the tool should be smart enough to invoke the (nolock) hint to avoid any database locking when querying a SQL database. Most users aren't advanced enough to understand how to do this in the SQL statement. It should be done automatically or at the very least, a check box option for user.

2 Comments
Magnetar
Magnetar

Hi,

Out of curiosity, have you tried the "Read Uncommitted" option in the Input Data tool?

My understanding is that this provides equivalent functionality to the (NOLOCK) hint, and this is a checkbox within the tool itself.

Alteryx
Alteryx
Status changed to: Not Planned

@Claje is correct, the read uncommitted checkbox allows for this functionality. It is also not always desirable to read uncommitted rows so we don't do this by default.