The goal of ITrpc is to provide some common IT utility functions.
You can install it from GitHub with:
# install.packages("devtools")
devtools::install_github("pfc5098/ITrpc")
A Redshift database connection can be established with the following three steps:
usethis::edit_r_environ()
to open the .Renviron file.REDSHIFT_USER = username
REDSHIFT_PASSWORD = password
REDSHIFT_HOST = host_ip_address
REDSHIFT_PORT = port_number
REDSHIFT_DBNAME = database_name
connect_redshift()
to create the connection.con <- ITrpc::connect_redshift()
Disconnect from the database with:
DBI::dbDisconnect(con)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.