greenplum_connect: Setup Greenplum Database Connection

In joshua-ruf/fidelis: Automate Data Reporting

Description

This function establishes a RPostgreSQL database connection.

• greenplum_connect() creates a Greenplum connection object, conn;

• greenplum_disconnect() disconnects conn and removes it from the global environment;

• create_secret() writes a password to 'C:/Users/<user>/Documents/Secrets/secret.rds', and creates a new directory if necessary

Usage

greenplum_connect(ask = T)

greenplum_disconnect()

create_secret()

Arguments

ask	Logical, if TRUE (default) then RStudio will ask the user to input their database password, if FALSE then password will be read from secret.rds

Note

Database connection created with RPostgreSQL rather than RPostgres or RGreenplum as only RPostgreSQL can run multiple queries with one db call.

joshua-ruf/fidelis documentation built on July 20, 2019, 1:56 a.m.