How to use AWS session token while creating the S3 credential in Sql Server

Question

I am using the following code block to create a credential for Sql Server. How can I work with session token if I use the temporary credentials?

CREATE CREDENTIAL [s3://datavirtualizationsample.s3.us-west-2.amazonaws.com/backup]
WITH    
        IDENTITY    = 'S3 Access Key'
,       SECRET      = 'accesskey:secretkey';
GO

Answer 1

Hi @Yeturu Jagadeesh Reddy

Try this:

CREATE CREDENTIAL [s3://datavirtualizationsample.s3.us-west-2.amazonaws.com/backup]
WITH    
        IDENTITY    = '<temporary_access_key_id>'
,       SECRET      = '<temporary_secret_access_key:session_token>';
GO

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".