Can't connect postgresql RDS via Secret Manager seems JSON serialize error

[zshnb]

Describe the bug
I setup aws connection in toolkit, then try connect via secret manager, when I test connection I got error
Unexpected character ('G' (code 71)): Expected space separating root-level values at [Source: REDACTED (StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION disabled)
To reproduce

1. open DataSource panel
2. fill host, choose secret manager auth
3. select credentials and region
4. fill secret name/arn
5. test connection

Expected behavior
connect success

Screenshots

Your Environment

• OS: MacOS
• JetBrains product: DataGrip 2024.2
• JetBrains product version: 2024.2
• AWS Toolkit version: latest
• SAM CLI version: aws cli 2.22.5
• JVM/Python version: 17

Additional context

[yogevyuval]

I think by the code that maybe the plugin expects the secret to be in a json format with more fields (hence the "use the url and port from the secret"), but this is not documented anywhere.

Try changing your secret to a json with "username" and "password" keys

[zshnb]

does there has any docs about it?

[yogevyuval]

does there has any docs about it?

None at all :(
It just worked for me though. {"username": "x", "password": "y"}

did you get it to work?

[zshnb]

I will try it, thanks