Hi guys,
I have set up a connection to a snowflake database. I am interested in setting the schema in the connection so that I dont connect by default to a specific one.
Kindly advise
con <- DBI::dbConnect(
odbc::odbc(),
"snowflake",
dbname = "xxxx",
role = "xxxxxx",
Trusted_Connection = TRUE
)