Panoply on Redshift
To connect your Panoply data warehouse to R:
-
Install the RPostgreSQL package. You can do this in your R environment by running the following:
install.packages("RPostgreSQL") library(RPostgreSQL)
-
Set up the connection to your Panoply data warehouse:
driver <- dbDriver("PostgreSQL") SampleConnection <- dbConnect(driver, host = 'db.panoply.io', port = '5439', user = '{your Panoply username}', password = '{your Panoply password}', dbname = '{the name of the Panoply DB containing your data}')
-
Load your data into an R dataframe for analysis:
SampleDF = dbReadTable(SampleConnection, '{table name}')