Redshift: Redshift DBI wrapper

In nfultz/AWR.Redshift: 'AWS' Redshift DBI Wrapper

Description

Redshift DBI wrapper

Authentication credentials are read from the DefaultAWSCredentialsProviderChain, which includes the .aws folder and environment variables.

Usage

Redshift()

## S4 method for signature 'RedshiftDriver'
dbConnect(drv, host, dbname, user, password, ...)

Arguments

drv	An object created by Redshift()
host	the host
dbname	S3 bucket where results will be saved to
user	Redshift schema to use
password	pw
...	Other options

See Also

Redshift Manual for more connections options.

Examples

## Not run: 
require(DBI)
con <- dbConnect(AWR.Redshift::Redshift(), region='us-west-2', 
                 s3_staging_dir='s3://nfultz-Redshift-staging', 
                 schema_name='default')
dbListTables(con)
dbGetQuery(con, "Select count(*) from sampledb.elb_logs")

## End(Not run)

nfultz/AWR.Redshift documentation built on May 7, 2019, 7:57 a.m.