conn is a working database connection. When I use
DBBI::dbGetQuery() I can execute SQL queries that explicitly mention the data catalog.
df <- dbGetQuery(conn," select * from <catalog>.<schema>.<table> limit 10 ")
Where can I supply this catalog name in
dbplyr::tbl(), which accepts only 2 arguments?
my_tbl <- tbl(conn, in_schema("<schema>", "<table>"))