sp_execute_external_script invoking a R script file

Question

I have a long R-script file and I would like to use SQL Server R Services, reading about its documentation, I have not seen any example of using: sp_execute_external_script that allows loading an R-script file. All examples are intended to use simple r-computation embedded in a SQL sentences, such as the following example:

DROP PROC IF EXISTS get_iris_dataset;  
go  
CREATE PROC get_iris_dataset  
AS  
BEGIN  
EXEC   sp_execute_external_script  
   @language = N'R'  
 , @script = N'iris_data <- iris;'  
 , @input_data_1 = N''  
 , @output_data_1_name = N'iris_data'  
 WITH RESULT SETS (("Sepal.Length" float not null,   
       "Sepal.Width" float not null,  
    "Petal.Length" float not null,   
    "Petal.Width" float not null, "Species" varchar(100)));  
END;  
go

I would need in some way to use the r-sentence source("fileName") for executing the r-sentences.

Note: I am trying to use an SQL Server just because a better machine performance than my personal computer.

Thanks in advance,

David

Are the R script files you are trying to source saved on the SQL Server machine? If so, you should be able to source then just like in R assuming there is read access to them. — Arun Gurunathan
– Arun Gurunathan, Commented Jul 23, 2016 at 0:34

Timror · Accepted Answer · 2016-07-25 14:45:10Z

5

It is certainly possible to use source("filename") you execute an R script. The R script should be located somewhere SQL Server has access to it. For instance: source("C:/Rscripts/script.R"). Note that SQL Server has no access to your My Documents folder...

EXEC sp_execute_external_script
@language = N'R'
,@script = N'
source("C:/Rscripts/script.R");'
,@input_data_1 = N''  
,@output_data_1_name = N'iris_data'  
WITH RESULT SETS (("Sepal.Length" float not null,   
 "Sepal.Width" float not null,  
 "Petal.Length" float not null,   
 "Petal.Width" float not null, "Species" varchar(100)));

answered Jul 25, 2016 at 14:45

Timror

7808 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sp_execute_external_script invoking a R script file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related