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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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.

1 Comment
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.