Supporting session_token for s3

[adrianhaj]

Is your feature request related to a problem? Please describe.

RisingWave should allow to use session_token when s3. Opendal is supporting this https://docs.rs/opendal/latest/opendal/services/struct.S3Config.html.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[hzxa21]

May I know in which case you are planning to use session token for? Is it s3 source/sink?

IIUC, session_token is used for temporary access to s3 resources and it needs to be manually refreshed. Correct me if I am wrong, session_token may not be suitable for sources/sinks used in streaming query because it will continuously run. It may be useful for ad-hoc query.

[adrianhaj]

May I know in which case you are planning to use session token for? Is it s3 source/sink?

IIUC, session_token is used for temporary access to s3 resources and it needs to be manually refreshed. Correct me if I am wrong, session_token may not be suitable for sources/sinks used in streaming query because it will continuously run. It may be useful for ad-hoc query.

We need session token only for testing on our dev envs because in this case we are not able to use roles and in our organization we have SSO with 2fa.