By using AWS re:Post, you agree to the Terms of Use

SageMaker Canvas connect Redshift failed

0

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

1 Answer
0
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

answered 9 months ago
EXPERT
reviewed 9 months 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.

Guidelines for Answering Questions