How to supply argument for data catalog to dbplyr::tbl()

General
1

Assume that 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>"))
2

This topic was automatically closed after 45 days. New replies are no longer allowed.


If you have a query related to it or one of the replies, start a new topic and refer back with a link.