RStudio

RStudio

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.

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}')

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