Can't read query of input tools when user access is lost to connection

[JelloRhino]

When a connection cannot be accessed successfully, such as when a password for a database has expired, I am unnecessarily prevented from seeing the entire query that it executes. Normally, I would click the three dots (...) to look at the query, but instead a failed connection message pops up preventing me from seeing it. I tried copying the query in the first picture in the "Table or Query" row, however only the first 1,000 character or so show, preventing me from looking at the query. 

It is sometimes useful when having to regain access to a database that you can view the query to discover what roles and permissions are fitting for the request. This also seems like an unnecessary limitation. My guess is that I could probably open the workflow XML in a text editor and look for the query but that really shouldn't be the solution to this. 

Am I missing something or would this be a possible feature addition?

 

 

[cjaneczko · Accepted solution]

You can see it under Workflow Dependencies. On the next window, click on the blue hyperlink that says "Show Individual Tools". This will show you all of your queries and data sources in the workflow even if you cant run them.