We have been using RazorSQL, but noticed that there are several annoying issues with this tool when running against Vertica. Is there a "better" client to use? What do most people use here?
Check out the "DbVisualizer Free for Vertica Distribution"!
We are using DBeaver extensively in our Vertica systems. You can try that too.
Would you be able to supply any details on the issues you've seen with RazorSQL? We have done some cursory connectivity and data type tests with it, and created a connection guide. During that time we didn't see any issues beyond the function ones listed in the guide, so we wanted to get more details on what you were seeing.
The connection guide:https://www.vertica.com/kb/Vertica-Integration-with-RazorSQL-Connection-Guide/Content/Partner/Vertica-Integration-with-RazorSQL-Connection-Guide.htm?Highlight=razorsql
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.