redshift.query: Executes a query

In pingles/redshift-r: Easier access to AWS Redshift clusters

Description

Executes a query and returns the result set as a dataframe.

Usage

redshift.query(conn, ...)

Arguments

conn	The database connection
...	Strings representing the query. These will be concatenated together with paste to make it easier to write multi-line queries

Value

Data frame containing the results.

Author(s)

Paul Ingles

Examples

require(redshift)
# conn <- redshift.connect("jdbc:postgresql://blah.blah.eu-west-1.redshift.amazonaws.com:5439/data", "username", "password")
results <- redshift.query(conn, "SELECT MAX(timestamp)",
                                "FROM weblog")

pingles/redshift-r documentation built on May 25, 2019, 7:13 a.m.