Collecting very large datasets from SQL server through R

General
,
1

Hi,
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.

Thanks

2

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

3

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.