Workflow$connect_dbi

Workflow$connect_dbi() → DBI::DBIConnection

Returns a DBI connection that can be used by dbplyr and other interfaces that work with DBI. This connection is scoped to the respective workflow, avoiding the need to fully qualify tables.

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

Returns:

DBI::DBIConnection

Examples

con <- redivis$workflow("imathews.example_workflow_climate_analysis")$connect_dbi()

tbl(con, "join_lat_lon_output") |> filter(latitude > 0) |> collect()

# Prints a tibble with the filtered data