AWS Glue error to write redshift after 1 hours

I have had the same problem, the solution is to create a role that allows you to write to S3 and add the role in Glue when writing data

connection_options = {"dbtable": "table_name", 
                     "database": "mydb", "aws_iam_role": "arn:aws:iam::XXXXXXXXXX:role/RedshiftS3Role"}