Connecting R with Database | Large Query Result

Hi! Welcome!

I think it will be easier for people here to help if you can narrow down your question a little bit. What are you looking for help with first?

  • Constructing the code to connect to and query the database?
  • Advice on how feasible your plan is performance-wise, or other approaches you might consider?
  • Pointers to resources for learning how to wrangle data with data.table? (when I’m in data.table land I always keep a cheat sheet handy!)
  • Specific help with data.table code?
  • Something else?

An important note: if you have questions about specific code, it’s going to be easiest to get help if you can provide an as-reproducible-as-possible example of what you’ve got so far, even if it’s not working right.

1 Like