Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Redshift GetClusterCredentials - DurationSeconds Question

0

Hi,

I have a general question regarding Redshift's GetClusterCredentials API.
The DurationSeconds can be set to maximum value of 3600 seconds / 1 hour.

If a user is connected to the cluster with temp. credentials obtained trough the GetClusterCredentials API, will he automatically be unable to execute SQL queries after 'DurationSeconds' seconds or only unable to login again after 1 hour with the same credentials?

In other words, would a business user

  • need to re-connect each hour to execute queries
  • or would the redshift session remain open and he can execute queries the whole day (unless he disconnects)

Thanks much

Topics
Analytics
Tags
Amazon Redshift
Language
English
asked 5 years ago634 views
1 Answer
0

Hi rstel,

I believe it's the interval the credential and any session obtained with the credential is valid. IOW, the connected session should timeout at the end of the interval and require obtaining an new temporary credential.

So, yes there is different behavior here compared to a session obtained with a Redshift user/pwd credential login that will typically last until something outside of Redshift causes the session to be severed below the application layer, like NAT port recycling or TCP layer timeout.

Regards,
-Kurt

answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content