We have a requirement for running an R Model to produce some results for us. The flow we would like to go with is:
SnowFlakes(Data Warehouse) -- > tExecuteRScript ----> SQL Server
I want to pull data from snowflakes which is in the cloud and then pass the data through the R script and store the output to SQL server. I have installed the tExecuteRscript but for some reason I am not able to establish a connection between SnowFlakes and R. Any help will be appreciated.
Please note that this is a starting/generating component, not a processing component. This means that incoming data connections are not allowed here.
To use it, just write down in the box the code you want to be executed by R. Please note this must be correctly quoted and escaped. Alternatively, you can source a code from an external .R file.