redivis$connect_dbi

redivis$connect_dbi() → DBI::DBIConnection

Returns a DBI connection that can be used by dbplyr and other interfaces tha work with DBI. This connection will be globally scoped, and all table names must be appropriately qualified.

To create a connection scoped to particulary dataset or workflow, see:

• Dataset$connect_dbi()

• Workflow$connect_dbi()

For advanced use cases, you can also access the Redivis DBI interface at redivis::RedivisDBI. redivis$connect_dbi() is the same as calling: DBI::dbConnect(redivis::RedivisDBI())

Returns:

DBI::DBIConnection

Examples

con <- redivis$connect_dbi()

tbl(con, "demo.ghcn_daily_weather_data.stations") |> filter(latitude > 0) |> collect()

# Prints a tibble with the relevant weather stations