Alteryx Designer Ideas

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

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

Submission Guidelines
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

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.

14 - Magnetar


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.

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.