Actual query text varies depending on the source database. DatabaseName, m. Vertica jdbc IN This query must returns two columns: full synonym name and full table name. Its the one that worked for me. Verticas connect string uses databasename, not schema name after (.