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?
[duplicate ] see comment below.
I found the best support for Vertica RDBMS is in DBVisualizer:
Any response from the Vertica employees on their tool of choice? DBeaver doesn't scale well
Get the free version and license:https://www.vertica.com/blog/dbvisualizer-free-for-vertica-distribution-updates/
If is about scalability I would recommend DbSchema designer for Vertica. The tool is diagram-oriented and scales nice on large databases. The tool loads the schema locally, so you can deploy or compare with other databases, generate migration scripts.
One more free interesting tool you can find from the same company is dsql. Is a command line client. If you have to deal with multiple databases (can be also different Rdbms) can do some magic operations and save a lot of time.