3 Replies Latest reply on Dec 11, 2018 5:28 PM by Nathan Mannheimer

    Write back to amazon redshift using r

    Vaibhav Luthra

      Hi,

       

      I have a requirement of using r code and writing back values of tableau parameters to database. I am using below code for this purpose.

      Given code works perfectly fine on R, however, tableau throws popup of start time to run the table calculation and never ends(waited for 10 mins max).

      Below is my code, please suggest what is causing issue and how this can be resolved.

       

      SCRIPT_INT("

      install.packages('RJDBC');

      library(RJDBC);

      driver <- JDBC('com.amazon.redshift.jdbc41.Driver', 'RedshiftJDBC41-1.1.9.1009.jar', identifier.quote='`');

      url <- 'jdbc:redshift://aws-a0036-use1-1b-d-red-shrd-chb-dev01.cnnhjxs6xgos.us-east-1.redshift.amazonaws.com:5439/test?user=test&password=test';

      conn <- dbConnect(driver, url);

      dbSendQuery(conn, 'insert into test.r_test values(.arg1);')

      ",

      MAX([R Param]))