Pasting query code for in-db connection never works the first time, re-pasting works.

[JoeCat]

Strange quirk.  Whenever I set up a "Connect in-db" tool for the first time, if I paste sql into the the query editor box, the code is immediately greyed out as if it were commented-out.  I then run it, it fails, and what I pasted is usually not in the field anymore.  I repaste the exact same thing into it and it works, the code is properly showing the color coding and what not.

[AlteryxMatt]

Hello @JoeCat!

I think this may be a good candidate to report through my.alteryx.com to ensure Customer Support is aware and can provide insight into resolution. The case submission process will also search the Knowledge Base in case there is a known solution

[apathetichell]

I think this is an issue with caching/cache retrieval. Your Connect In-DB needs to retrieve the cache of tables/schemas/dbs (objects) prior to letting you paste in a SQL query.

[JoeCat]

Interesting, that would make sense.  Though pasting it the first time really seems to do literally nothing. Its not running or executing the code.  Maybe slightly different than I originally described, If i paste ... it doesnt work, then click onto canvas, go back into the tool paste again and it works.

[apathetichell]

Is your connect in-db blank when you return? If so - i've seen that and always assumed it was a caching issue - ie I posted the query before the tool was ready. I vaguely remember Snowflake was the main culprit here - and the setup was an absurd amount of DB objects.

[JoeCat]

Yes exactly that.  You paste it looks commented out, and then you come back and it is blank.  

[apathetichell]

so my assumption is that's just caching. I kind of was like - it's an issue but not a huge issue. I also stopped using connect in-db and started using dynamic input in-db in almost all cases.