Skip to content

Instantly share code, notes, and snippets.

@randyzwitch

randyzwitch/redshift.R

Created November 20, 2013 16:21
Show Gist options
  • Save randyzwitch/7566041 to your computer and use it in GitHub Desktop.
Save randyzwitch/7566041 to your computer and use it in GitHub Desktop.
Download ZIP
Redshift
Raw
redshift.R
library("RPostgreSQL")
#Connect to Redshift
redshift.Connection <- dbConnect(dbDriver("PostgreSQL"), host="XXXXXXXXXXXXXXX.redshift.amazonaws.com", dbname="XXXXXXXX",
user="XXXXXXX", password= "XXXXXXXXXX", port=XXXXXXXX)
query_string <-
"select *
from table
where something = 'True';"
results <- dbGetQuery(redshift.Connection, query_string)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment