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

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

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file