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:
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 = TRUEtells 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.