Data Source "Redshift (with IAM User/Role)" does not support Redshift Serverless

[roki18d]

Issue Summary

As title, the data source "Redshift (with IAM User/Role)" is only for Redshift Provisioned Cluster, and does not seem to support Redshift Serverless.

I think, "Redshift (with IAM User/Role)" would be data source using Federated Identity, which is Redshift authorization feature. Officially in AWS, Federation ID supports both Redshift Provisioned Cluster and Redshift Serverless, but the Redash data source only supports the former.

Also, there might be some bugs like:

• The property named IAM Role Name should be filled with IAM Role ARN.
• User property looks like required one, but I think either IAM Role Name/ARN or User is required. (If this property expects IAMR:{role-name} format, this might not be a bug.)

Steps to Reproduce

1. [Settings] -> Click [+ New Data Source] -> Search and select [Redshift (with IAM User/Role)] data source
2. In data source properties, there is Redshift Cluster ID but not Redshift Serverless WorkGroup. When I tried to fill Redshift Cluster ID with my Redshift Serverless WorkGroup name and test connection, I got the following error message.

Connection Test Failed:
An error occurred (ClusterNotFound) when calling the GetClusterCredentials operation: Cluster analysis-prod-main-wg not found.

Screenshot for data source addition dialogue

Screenshot for test connection error message

Technical details:

• Redash Version: redash/redash:10.1.0.b50633
• Browser/OS: Google Chrome 123.0.6312.122（Official Build） （arm64）
• How did you install Redash: Build Redash services on ECS Service with Docker. The Database engine for Redash is Amazon Aurora PostgreSQL.

[AndrewChubatiuk]

hey @roki18d please try to use changes from https://github.com/getredash/redash/pull/6914 added there redshift serverless support

[roki18d]

Hi, @AndrewChubatiuk Thank you for your quick response and PR submission for the issue!