I am using open sourced RStudio server installed on AWS linux EC2 instance. The database snippet files are kept in /etc/rstudio/connections
path on linux instance.
I successfully connected the SQL database in RStudio using snippet files. After successful connection, connection pane is not showing SQL button. Ideally there should be SQL button to access tables from connected database.
But, cannot find a way to execute instant query on connected database. How can I execute instant SQL query on connected database in R Studio itself?