I'm at my wits end. I have an ODBC connection to Snowflake/Azure SQL and for elements in one of my db's, I easily get the columns. However, in another DB, they will not populate. I've hit F5 and shift F5, changed the caching to on and off (tools, view, odbc), until I've almost worn out the keys. Rebooted, etc. And, it's occurring on 2 different PC's. The db's are large--no doubt--but similar sized db's work. No amount of waiting seems to work (left it connected all weekend).
I was getting some of the columns if I literally walked through each schema one by one--but at some point it hit a table that wouldn't return results and then it would not do any more. I get the "generating columns" message but it doesn't. It just gives an empty column display. I can view the data--but not the columns.
This impacts the ability to use the Build query option. I have this article from a few years ago Vertica tables dropped into Query Builder issue that also describes the symptoms. But, it doesn't work.