I am using a desktop version of RStudio. My colleagues are very excited by visuals and narratives that I can create in RStudio, but our database admins are not very interested in supporting RStudio. They only support PyCharm.
I have managed to create a package that connects RStudio to Vertica through RJDBC, but we also have a lot of data in AWS, Redshift, and Athena. I have tried using the available online resources but have not been able to connect RStudio to Redshift and Athena. We can connect PyCharm to all our databases, but I am wondering if there is there any kind of paid service that can help trouble shoot connections to corporate databases?