When you test a connection, you specify an IAM role that will be used to access resources. That role needs certain permissions. In your case, it seems you're using a role called
As the error says, that role needs a policy that allows the action
glue:GetConnection on the resource
arn:aws:glue:us-west-2:xxxxxxxxxxxx:catalog. You'll also need a permission for same action over those two connections if no policy includes it already.
Typically with AWS Glue, you'd use a role that includes the
AWSGlueServiceRole AWS managed policy as described in the Setting up IAM permissions for Glue documentation, although you might want to use self-managed policies for more granular controls.
In that case, in the IAM console, click on Roles, search for Awsglue and click on that role. There you will see all the policies attached to that role. Modify one of those existing attached policies or add a new one that includes that action on the necessary resources (catalog and connections). However, you'll likely need to add more permissions to that role if you are going to use it for other purposes in AWS Glue (e.g.: ETL jobs to write to S3). Check adding identity permissions and Actions, resources, and condition keys for AWS Glue in the IAM documentation for further reference.
No resource to display when configuring AWS Cloud9 for a teamasked 8 months ago
"Resource Unavailable" in AWS GlueAccepted AnswerEXPERTasked 2 years ago
AWS Glue Monitoring errorasked 2 months ago
No identity-based policy allows the ssm:SendCommand actionasked 4 months ago
Policy that allows only one SSO user to access a resourceAccepted Answerasked a month ago
Include s3:ListObjectsV2 as action in bucket policyasked a year ago
SecurityHub Access Denied because no identity-based policy allows the config:GetComplianceDetailsByConfigRule actionasked 14 days ago
Unable to create Glue Resource Policyasked a year ago
AWS Glue setup has error glue:GetConnection on resource: arn:aws:glue:us-west-2:876911572231:catalog because no identity-based policy allows the glue:GetConnection action .asked a month ago
Cannot setup CodeCommit because there is no Source Control setupasked 4 months ago