Hi,
I'm trying to fetch some data from SQL into R using the following code:
library(RODBC)
conn3 <- RODBC::odbcDriverConnect( 'driver={SQL Server};server=SERVERNAME;database=DB_NAME;trusted_connection=TRUE' )
my_data <- RODBC::sqlFetch(channel = conn3 ,sqtable = "Table name" ,stringsAsFactors = FALSE ,na.strings = "")
The data set is 1,032,576 KB and so unsurprisingly when I try to fetch from SQL to R I get an error message saying the memory has been exceeded.
Is there an R package that pulls data in from SQL and stores it in a way that means that the memory isn't exceeded?