in_schema: Refer to a table in a schema or a database catalog

In dbplyr: A 'dplyr' Back End for Databases

Refer to a table in a schema or a database catalog

Description

in_schema() can be used in tbl() to indicate a table in a specific schema. in_catalog() additionally allows specifying the database catalog.

Usage

in_schema(schema, table)

in_catalog(catalog, schema, table)

Arguments

catalog, schema, table

Names of catalog, schema, and table. These will be automatically quoted; use sql() to pass a raw name that won't get quoted.

Examples

in_schema("my_schema", "my_table")
in_catalog("my_catalog", "my_schema", "my_table")
# eliminate quotes
in_schema(sql("my_schema"), sql("my_table"))

# Example using schemas with SQLite
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")

# Add auxiliary schema
tmp <- tempfile()
DBI::dbExecute(con, paste0("ATTACH '", tmp, "' AS aux"))

library(dplyr, warn.conflicts = FALSE)
copy_to(con, iris, "df", temporary = FALSE)
copy_to(con, mtcars, in_schema("aux", "df"), temporary = FALSE)

con %>% tbl("df")
con %>% tbl(in_schema("aux", "df"))

dbplyr documentation built on Oct. 26, 2023, 9:06 a.m.