Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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
Claje
14 - 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.

jpoz
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.