We have many Redshift packages that sync data from salesforce and zendesk to our redshift cluster. Recently, all packages stopped working with the error "AWS Access Key ID is not specified.". We have not made any changes to the connection or the packages, so this appears to be a bug that we need fixed urgently in order to report on our salesforce data. I have tested the AWS Access Key ID and Secret Key that are stored in the connection, and the keys still work just fine for uploading data into s3 and other actions.
I have attached a screenshot of the redshift connection that shows a successful connection.
Thank you for your support, and I look forward to hearing back about a resolution.