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

Unable to establish connection to Amazon Redshift from AWS Glue

0

Unable to establish connection to Amazon Redshift from AWS Glue. It was working before with the same setting i am using right now.

  1. Checked publicly accessible setting in Redshift
  2. Create a VPC endpoint for S3
  3. Configured security group with correct rules
  4. Verified the credentials
  5. Verified iam role attached to AWS Glue by even providing admin privileges.
  • Gonzalo Herreros EXPERT
    a year ago

    Could it be that the VPC lost internet access or the Redshift endpoint (you mention the s3 but not for Redshift)?

Topics
Networking & Content DeliveryAnalytics
Tags
Amazon VPCAWS GlueAmazon RedshiftSecurity Group
Language
English
rePost-User-5773048
asked a year ago727 views
1 Answer
0
Accepted Answer

Hi,

You should try to create a glue endpoint in the same region of your glue connection. Moreover, verify that you glue connection is attached to the right VPC/Subnet/SG.

Melfani
answered a year ago
  • rePost-User-5773048
    a year ago

    thanks for your valuable inputs. I verified it was VPC which was creating the trouble and it was an issue for the network I was connected on. I tried with another machine and on the different network and my issue got fixed.

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

Relevant content