Wings 1 T15 Wings Load Data from Amazon S3 bucket to Redshift using AWS glue 80827| part 12 | TCS

[@sohamshinde2002]

Can you please make a video on t13 course as from where to prepare and the material part as well as the fresco play part

[@DeepthiDadi]

AZ-900 Microsoft Azure Fundamentals assignment pls

[@praveeny4307]

Hi sir, we are getting some error while trying to create a connection btw glue and redshift, it is asking us to check some secret manager, tried many ways but nothing is working out

[@flarestudy5844]

Hi @praveeny4307 I am mentioning some ways to solve your problem please try these below ways, I hope your issue will be resolved once you follow these ways
1. Verify Secret in Secrets Manager:
- Ensure the secret with Redshift credentials in AWS Secrets Manager is correctly set up (username, password, DB name, cluster, port).
2. Check IAM Permissions:
- Confirm that the IAM role used by the Glue job has `secretsmanager:GetSecretValue` permissions.
3. Update Glue Job:
- Ensure your Glue connection is configured to use the correct secret from Secrets Manager.
4. VPC and Security Groups:
- Check the VPC, subnet, and security groups to ensure Glue can access Redshift.
5. Test Connection:
- Use AWS Glue’s “Test Connection” feature to verify the connection to Redshift.
6. Logs and Debugging:
- Review CloudWatch logs for specific error messages to get more insights.