I have a Shiny application that reads data from a Postgres table in AWS Redshift and when running locally, works fine. When I try and publish the app, it publishes fine but when the page renders, the data never loads. The connection is set up using a config.yml
file where I define my server/host, user, password, and port. In the dbConnect
statement, I use RPostgreSQL::PostgreSQL()
for the driver from the DBI
package. Am I missing something obvious here? I even tried hardcoding the parameters for a test instance but no luck. All the application is doing in this case is getting the data with a dbGetQuery
and then displaying the data using renderDataTable
.
This topic was automatically closed 54 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.