# Workflow$connect\_dbi

### **Workflow$**<mark style="color:purple;">**connect\_dbi**</mark>**()** → [DBI::DBIConnection](https://dbi.r-dbi.org/reference/DBIConnection-class.html)

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.

{% hint style="info" %}
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))`
{% endhint %}

### **Returns:**

[**DBI::DBIConnection**](https://dbi.r-dbi.org/reference/DBIConnection-class.html)

### Examples

```r
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
```