How to fix errors when writing to a Redshift DB?

When writing to a Redshift database table, you need to grant permission to Openprise to write to the table. The error message received will look similar to this if your permissions aren't set up properly:

"Error while executing copy from bucket for ruleId:dtId: 82762-555;error: permission denied for relation export_test".

To fix the problem, have your Redshift administrator apply the commands below:

GRANT ALL PRIVILEGES ON TABLE TO ;

or

GRANT CONNECT ON DATABASE TO ;

— This assumes you're actually connected to your database

GRANT USAGE ON SCHEMA TO ;

GRANT SELECT,UPDATE,INSERT,DELETE ON TO ;