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
.