This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You're doing everything right. The only thing that I can think of is the actual SQL - have you tested this outside of Alteryx? Could it be that the user ID is a number rather than a string? In which case you'll need to get rid of the single quotes.
Given your limited workflow, you would also need to make a change to the Interface Designer properties to include the "browse tool" in your output. When an App is running all browses are disabled unless you explicitly call the out for viewing.