I am unable to create a derived table on AWS JRS Pro (hourly).
Queries return:
*********
The query encountered an error:
com.jaspersoft.commons.semantic.metaapi.MetaDataException: Cannot execute JDBC Query.
org.postgresql.util.PSQLException: ERROR: permission denied for relation public.test_table
*********
The queries all run successfully from our DB management tools.
JRS can successfuly query the database for the list of tables and attributes to build the domain, so it has authenticated into Redshift.
Thanks
