Redshift Serverless 'ContainerStateException' when accessing Query V2 via IAM Identity Center

Hello :)

I am trying to use Redshift Query Editor V2 authenticating via IAM Identity Center. These were my setup steps:

• Created IAM Identity Center in the same region of the Serverless Workgroup
• Created a Serverless Redshift instance (note I tried both private and publicly accessible workgroup, also being deployed on public subnets)
• Create IAM Identity Center Application via the Redshift console
• Enabled Query editor v2 application
• Added the IAM IdC group containing my user (which is a group that has Administrator privilieges, therefore it is not a credentials limitation issue)

When I try to login I get this error on the QEV2 console: Databases couldn't be listed.. However upon further investigation on Cloudtrail I can see these details on the event:

"errorCode": "InternalServerErrorException",
    "requestParameters": {
        "path": "/cluster/connect/",
        "data": "***",
        "version": "1.001"
    },
    "responseElements": {
        "result": false,
        "code": "ContainerStateException",
        "error": "Cannot get container for user AROAYWI5C7KHET6MY5CL5:<USERNAME>",
        "message": "Cannot get container for user AROAYWI5C7KHET6MY5CL5:<USERNAME>"
    },

I couldn't find anything in the documentation about this error. Any help of what I might have messed up in the setup or elsewhere is much appreciated.