Marlon Ribunal has a quick demo showing how to generate a ggplot2
plot using SQL Server Machine Learning Services:
Let’s install the package if it hasn’t been installed yet. The easiest way to do that is to run RGUI.exe that came with your SQL Server 2017 In-Database Machine Learning installation. You can find it here:
C:\Program Files\MSSQL14.MSSQLSERVER\R_SERVICES\bin\x64
Take note that you need to run the executable as Administrator. Also, if you’ve installed the R engine prior to your SQL Server 2017 In-Database Machine Learning with R, you have to explicitly tell the R package installer where you want your package installed.
> install.packages("ggplot2", lib="C:\\Program Files\\Microsoft SQL Server\\MSSQL14.MSSQLSERVER\\R_SERVICES\\library", dep = TRUE)
dep = TRUE
tells the installer to install dependencies. ggplot2 depends on a lot of other packages. You can check dependencies using MiniCRAN.
Another option for installation is to bootstrap install via T-SQL: you can execute external scripts which run install.packages()
directly rather than using RGUI, if that makes more sense with your deployment process.