R/olap.R

In Kidapt/keda: A Package to Support Exploratory Data Analysis

#' Say what this function does in one line
#'
#' databases to call in query(). Note that you need to make sure the workstation is connected to the right VPN to access the kidapt database
#' @param config_file is the config file storing all of your passwords and credentials. It is based on the config_local.yml file in the project's root directory.
#' @keywords olap database config
#' @export
#' @examples
#' query(olap, "select * from question_answer limit 6")

olap <- function(config_file = here::here("config.yml")){
  server <- config::get(file = config_file)

  dbConnect(
    RPostgreSQL::PostgreSQL(),
    user = server$db_olap$user,
    password = server$db_olap$password,
    dbname = server$db_olap$dbname,
    host = server$db_olap$host,
    port = server$db_olap$port
  )
}