To view the path of your vertica database:
1- Run the Administration Tools.
$ /opt/vertica/bin/admintools
2- From the Main Menu, select Configuration Menu and click OK.
3-Select View Database and click OK.
4-Select the database you want would like to view and click OK to see the database profile.