src_dbi

<a href="https://lifecycle.r-lib.org/articles/stages.html#superseded"><img src="figures/lifecycle-superseded.svg?package=dbplyr&version=2.4.0" alt="[Superseded]"></a>
Since can generate a <code>tbl()</code> directly from a DBI connection we no longer
recommend using <code>src_dbi()</code>.

internal

A 'dplyr' back end for databases that allows you to work with
remote database tables as if they are in-memory data frames.  Basic
features works with any database that has a 'DBI' back end; more
advanced features require 'SQL' translation to be provided by the
package author.

Hadley Wickham

dbplyr

A 'dplyr' Back End for Databases

Maximilian Girlich

Edgar Ruiz

RStudio 

src_dbi function

<dl><dt>con</dt>
<dd>An object that inherits from <a href="https://dbi.r-dbi.org/reference/DBIConnection-class.html">DBI::DBIConnection</a>,
typically generated by <a href="https://dbi.r-dbi.org/reference/dbConnect.html">DBI::dbConnect</a></dd>
<dt>auto_disconnect</dt>
<dd>Should the connection be automatically closed when
the src is deleted? Set to <code>TRUE</code> if you initialize the connection
the call to <code>src_dbi()</code>. Pass <code>NA</code> to auto-disconnect but print a message
when this happens.</dd></dl>

Arguments

<a href='https://lifecycle.r-lib.org/articles/stages.html#superseded'><img src='figures/lifecycle-superseded.svg' alt='[Superseded]' /></a>
Since can generate a <code>tbl()</code> directly from a DBI connection we no longer
recommend using <code>src_dbi()</code>.

Database src — src_dbi

<dl>

<dt>con</dt>
<dd>An object that inherits from <a href='https://dbi.r-dbi.org/reference/DBIConnection-class.html'>DBI::DBIConnection</a>,
typically generated by <a href='https://dbi.r-dbi.org/reference/dbConnect.html'>DBI::dbConnect</a></dd>


<dt>auto_disconnect</dt>
<dd>Should the connection be automatically closed when
the src is deleted? Set to <code>TRUE</code> if you initialize the connection
the call to <code>src_dbi()</code>. Pass <code>NA</code> to auto-disconnect but print a message
when this happens.</dd>

</dl>

src_dbi: Database src

Description

Usage

Value

Arguments