SageMaker Canvas connect Redshift failed

Question

Try to add the Redshift connection on SageMaker Canvas to import the data

- The cluster identify: redshift-cluster-1
- database name: dev
- database user: awsuser
- unload IAM Role: my-reshift-role
- connection name: redshift
- type: IAM

my-reshift-role trust-relationship is trust the "redshift.amazonaws.com" and "sagemaker.amazonaws.com"

Expectation: create connection successfully

Actually result: 
RedshiftCreateConnectionError
Unable to validate connection. An error occurred when trying to list schema from Redshift

Accepted Answer

The sagemaker canvas using sagemaker domain user, so need add the Redshift permission to the IAM Role attached to domain user. After add the permission, the connection can be setup

SageMaker Canvas connect Redshift failed

Contenido relevante