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

Question

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.

apathetichell · Answer

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.

JoeCat · Answer

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

apathetichell · Answer

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.