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
+1Here 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 = ",")
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
