sql_write

<a href="https://lifecycle.r-lib.org/articles/stages.html#experimental"><img src="figures/lifecycle-experimental.svg?package=epidm&version=1.0.4" alt="[Experimental]"></a>
Write a table object to a SQL database. Acts a wrapper for odbc and DBI
packages with additional checks to ensure upload completes.

Contains utilities and functions for the cleaning, processing and
management of patient level public health data for surveillance
and analysis held by the UK Health Security Agency, UKHSA.

Alex Bhattacharya

epidm

UK Epidemiological Data Management

sql_write function

<dl><dt>x</dt>
<dd>a data.frame/data.table/tibble object</dd>
<dt>server</dt>
<dd>a string containing the server connection</dd>
<dt>database</dt>
<dd>a string containing the database name within the data store</dd>
<dt>tablename</dt>
<dd>a string containing the chosen SQL database table name</dd></dl>

Arguments

<a href='https://lifecycle.r-lib.org/articles/stages.html#experimental'><img src='figures/lifecycle-experimental.svg' alt='[Experimental]' /></a>
Write a table object to a SQL database. Acts a wrapper for odbc and DBI
packages with additional checks to ensure upload completes.

Write a table to a SQL database — sql_write

<dl>

<dt>x</dt>
<dd>a data.frame/data.table/tibble object</dd>


<dt>server</dt>
<dd>a string containing the server connection</dd>


<dt>database</dt>
<dd>a string containing the database name within the data store</dd>


<dt>tablename</dt>
<dd>a string containing the chosen SQL database table name</dd>

</dl>

sql_write: Write a table to a SQL database

Description

Usage

Value

Arguments