Collecting very large datasets from SQL server through R

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.


You can use dbplyr to use R syntax that gets translated into sql code and executed in the RDBMS under the hood.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.