sqldb_retrieve: Title Import dataset from SQL server into R

In DHatziioanou/simpleepi: Simplifying functions to improve the ease and speed of basic epidemiological analysis

Title Import dataset from SQL server into R

Description

Title Import dataset from SQL server into R

Usage

sqldb_retrieve(
  name = "dt",
  server,
  database,
  schema_name = NULL,
  dataset,
  columns = FALSE,
  top = FALSE
)

Arguments

name	name to call retrieved data in environment
server	Server holding data
database	Database to query
schema_name	dataset schema eg "dbo"
dataset	table or view dataset name
columns	column names
top	Optional number of top rows to retrieve

Value

Dataset contents as defined by arguments from SQL server

Examples

# sqldb_retrieve(name ="dt", server="x", database="W001", dataset ="x_linelist_v1")
# sqldb_retrieve(name ="dt", server="x", database="W001", dataset ="x_linelist_v1",
                    # columns=c("id", "value"), top =100)

DHatziioanou/simpleepi documentation built on Sept. 24, 2024, 5:25 a.m.