I am attempting to complete the 'Building a Data Warehouse' course as an individual who is a beginner Data Analyst. In part 1 of the course, the first module has you use an RDS Query component. When I get to the step to add the SQL query to get data from the RDS Database, I am encountering an error (screenshot attached). I followed the training's instructions, and used their credentials that are given, but i'm still denied access. The error says "Could not connect: Access denied for user 'srcuser'@'ec2-44-204-125-37.compute-1.amazonaws.com' (using password: YES)"
Hi @paulina.thrasher and welcome to the forums!
The team has tested the connection to the RDS database and everything seems fine on our side. The issue might be related to the specific permissions you have on your Matillion ETL instance to access public resources, in this case the RDS database we provide.
Could I ask you to check with your infrastructure team to make sure you have the permissions required in place, please?
Let me know how you get on!
Many thanks,
Claire
I am attempting to complete the 'Building a Data Warehouse' course as an individual. My getting below error while giving MySQL endpoint as from notes. I am unable to complete the first part of the course.
Hi @vijay.kalsi
The screenshot you've posted seems to be taken from the new Data Productivity Cloud Designer and "Building a Data Warehouse Using Matillion" (the screenshot in the original post) is a Matillion ETL course — two different platforms. I need more clarity/details to be able to provide some guidance.
Thanks,
Chika