I am trying to find a way of collecting and joining 3 tables from an sql server. I am able to connect using the DBI and odbc packages. I am also able to use my sql code within R to make it work
As one of the tables i am pulling is extremely large, it is unreasonable to just collect it from the sql server and store on the r environment. So was wondering if there's a way of accessing the data remotely and doing it solely using r code.