import_data: import_data

In Choens/acuitasAdHoc: Acuitas Ad Hoc

import_data

Description

Looks for "file" in "folder". If it exists, it attempts to run the query AFTER running validation.sql if it exists. If validation.sql exists, all rows must return 1 (TRUE) before the report query in "file" will be run. If validation.sql fails, the function will stop for the number of seconds defined in wait_time before trying to rerun validation.sql.

Usage

import_data(file = "query.sql", folder = "sql", 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.
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.

Choens/acuitasAdHoc documentation built on March 18, 2022, 6:37 a.m.