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 indata.tableland I always keep a cheat sheet handy!) - Specific help with
data.tablecode? - 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.