import_data: import_data

In acuitas-health/ahUtils: Acuitas Utils

import_data

Description

Looks for "file" in "folder". If it exists, it attempts to run the query. The user may also pass a query directly to import_data.

Usage

import_data(
  file = "query.sql",
  folder = "sql",
  qry = NULL,
  config = NULL,
  verbose = FALSE,
  params = NULL
)

Arguments

file	The file where the query lives.
folder	The folder where the query lives. If validation.sql is in this folder it will be run BEFORE the sql file.
qry	A query to import, without a file.
verbose	If TRUE, this function talks a lot. Useful for debugging connection issues and not much else.
params	A LIST of parameters to alter the query.

Value

A data frame with your data. If the query doesn't return anything, you will receive an empty tibble.

acuitas-health/ahUtils documentation built on April 14, 2022, 9:41 a.m.