Set up other than default schema in DBI dbConnect connection

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
)