remote_name() gives the name remote table, or NULL if it's a query. remote_query() gives the text of the query, and remote_query_plan() the query plan (as computed by the remote database). remote_src() and remote_con() give the dplyr source and DBI connection respectively.

remote_name(x)

remote_src(x)

remote_con(x)

remote_query(x)

remote_query_plan(x)

Arguments

x

Remote table, currently must be a tbl_sql.

Value

The value, or NULL if not remote table, or not applicable. For example, computed queries do not have a "name"

Examples

mf <- memdb_frame(x = 1:5, y = 5:1, .name = "blorp") remote_name(mf)
#> <IDENT> blorp
remote_src(mf)
#> src: sqlite 3.22.0 [:memory:] #> tbls: blorp, cvpeammhtu, cyl8, mtcars, sqlite_stat1, sqlite_stat4, weaikfkbkz
remote_con(mf)
#> <SQLiteConnection> #> Path: :memory: #> Extensions: TRUE
remote_query(mf)
#> <SQL> SELECT * #> FROM `blorp`
mf2 <- dplyr::filter(mf, x > 3) remote_name(mf2)
#> NULL
remote_src(mf2)
#> src: sqlite 3.22.0 [:memory:] #> tbls: blorp, cvpeammhtu, cyl8, mtcars, sqlite_stat1, sqlite_stat4, weaikfkbkz
remote_con(mf2)
#> <SQLiteConnection> #> Path: :memory: #> Extensions: TRUE
remote_query(mf2)
#> <SQL> SELECT * #> FROM `blorp` #> WHERE (`x` > 3.0)