vertica.dplyr JDBC connection would it be possible to use a different schema than the public schema

lukethor

The vertica jdbc connection always default to the public schema. Is there a way to change schemas different than the public schema or to open the connection to a different schema ?

vertica <- src_vertica(dsn = NULL, jdbcpath="/ecrfiles/git/prometheus_distribution/ecrfiles/lib/external/vertica-jdbc-8.1.0-3.jar","hci3","localhost",5433,"dbadmin","eppassword")

Thanks in advance

ckotsidimos

Check this doc.
https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientJDBC/JDBCConnectionProperties.htm?Highlight=default schema

lukethor

Here is the answer how I use a different schema than public.
syntax : ' " schema" . " table" '
example : ' " epbuilder_proxy ". " expected_record" '

Example:
orig <- db_load_from_file(vertica, file.name= "/Users/foo/expected_records.csv",'"schema_proxy"."expected_records"', sep = ",")