RStudio on Redshift

RStudio on Redshift

Panoply documentation is moving! Click here to view the new site!  __________________________________________________________________________________________________________________

To determine whether your data warehouse is built on BigQuery or Redshift, see the BI Connect Page on the Panoply platform.

Panoply on Redshift

To connect your Panoply data warehouse to R:

  1. Install the RPostgreSQL package. You can do this in your R environment by running the following:

     install.packages("RPostgreSQL")
     library(RPostgreSQL)
    
  2. 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}')
    
  3. Load your data into an R dataframe for analysis:

    SampleDF = dbReadTable(SampleConnection, '{table name}')

 

Panoply on BigQuery

To connect RStudio to your BigQuery data warehouse to :

  1. Install the BigRQuery package. You can do this in your R environment by running the following:
  2. Load the DBI library and provide the connection details as shown below:

You have successfully connected R Studio to your BigQuery data warehouse.

Getting started is easy! Get all your data in one place in minutes.
Try Panoply Free