Failed setting up RedShift destination CopyDestination test failed

[pipat-flowacc]

The solution is granting an Airbyte user in RedShift to CREATE at database scope.
CREATE scope at the schema level is not sufficient.

GRANT CREATE ON DATABASE my_database TO airbyte_user;