Redshift Serverless query from Data API

Question

I seem to have trouble accessing the Redshift serverless resources from the Data API. The Data API does not respect the WorkgroupName attribute. Thoughts?

```
aws redshift-data list-databases --database dev3 --workgroup-name wg6 --region us-east-1

usage: aws [options]   [ ...] [parameters]
To see help text, you can run:

aws help
  aws  help
  aws   help

Unknown options: --workgroup-name, wg6
```

Ziad · Answer

Hi,

What is the version of the aws cli ? *aws --version*

I have just tried it and the workgroup-name attribute worked. It was tested with aws cli version 2.7.35.

Thanks,

Don_D · Answer

You need to authenticate using Secrets ARN or temporary credentials.

From https://docs.aws.amazon.com/cli/latest/reference/redshift-data/list-databases.html:

> Depending on the authorization method, use one of the following combinations of request parameters:
> 
> * Secrets Manager - when connecting to a cluster, specify the Amazon Resource Name (ARN) of the secret, the database name, and the cluster identifier that matches the cluster in the secret. When connecting to a serverless workgroup, specify the Amazon Resource Name (ARN) of the secret and the database name.
> * Temporary credentials - when connecting to a cluster, specify the cluster identifier, the database name, and the database user name. Also, permission to call the redshift:GetClusterCredentials operation is required. When connecting to a serverless workgroup, specify the workgroup name and database name. Also, permission to call the redshift-serverless:GetCredentials operation is required.

You can see examples of using Secrets Manager in this blog post: https://aws.amazon.com/blogs/big-data/using-the-amazon-redshift-data-api-to-interact-with-amazon-redshift-clusters/

Redshift Serverless query from Data API

Relevant content