AWS Glue - Test Data Connection
Under AWS Glue > Data Catalog > Connections > Create connection, a JDBC connection is created. Would like to test the connection, however, no IAM role is available for selection to proceed with the test. Even the IAM role with AdministratorAccess cannot be displayed. Please advise what am I missing. Thank you.
- Newest
- Most votes
- Most comments
As per [https://docs.aws.amazon.com/glue/latest/dg/set-up-iam.html#:~:text=Grant%20your%20IAM%20identities%20access%20to], access Glue > Getting started > Prepare your account for AWS Glue. AWSGlueServiceRole will appear.
It seems you're encountering an issue while trying to test a JDBC connection in AWS Glue. The fact that no IAM roles are available for selection, even one with AdministratorAccess, suggests there might be a configuration or permission problem. Here are some steps to troubleshoot and resolve this issue:
-
Ensure that you have the necessary permissions to view and select IAM roles. Even with an AdministratorAccess policy, there might be specific permissions required for AWS Glue operations.
-
Check if there are any IAM roles in your account that have the required permissions for AWS Glue. The role should have permissions to access the data store you're connecting to, as well as permissions for AWS Glue operations.
-
If you don't have a suitable role, you may need to create a new IAM role specifically for AWS Glue. This role should have the necessary permissions to access the data store and perform AWS Glue operations.
-
Verify that the IAM roles in your account are in the same region as your AWS Glue connection. AWS Glue operates on a regional basis, so the roles need to be in the same region as the connection you're trying to test.
-
If you've recently created a new role, there might be a slight delay before it appears in the AWS Glue console. Try refreshing the page or waiting a few minutes before attempting the test again.
-
Double-check that your AWS Glue service-linked role is properly set up. This role is usually created automatically when you start using AWS Glue, but if it's missing, you may need to create it manually.
-
If none of the above steps resolve the issue, you may want to contact AWS Support for further assistance, as there could be an account-specific issue or a temporary service problem.
Remember, when testing a connection, it's a best practice to use a role with the minimum necessary permissions for security reasons, rather than using a role with full administrative access.
Sources
Testing an AWS Glue connection - AWS Glue
Connecting to data - AWS Glue
Relevant content
- asked 3 years ago
- AWS OFFICIALUpdated 9 months ago
