I am taking up Building a Data Warehouse certification. In the Level 1 module , I am not able to connect to the RDS endpoint (mat-trn-src.co4vks4ks8wo.eu-west-1.rds.amazonaws.com:3306) provided in the interactive tutorial. Getting the following error during validation. Can you please help to resolve this to proceed with the certification ?
User: arn:aws:sts::926494931119:assumed-role/us1-mt-agents-prod-1-agents-a--od/i-0b9c6d8dee437f71e is not authorized to perform: rds:DescribeDBInstances on resource: arn:aws:rds:us-east-1:926494931119:db:* because no identity-based policy allows the rds:DescribeDBInstances action (Service: Rds, Status Code: 403, Request ID: a87609d3-bbfb-4cf6-9959-42a5082781a5)
Hey Tharani, welcome to the Matillion Community!
As noted at the start of the "Stage data" section of "Practical exercises - Level 1" - things vary depending upon if you are using your own agent, or if you are using the Matillion hosted agent. In your case (based on the error), it seems like you're trying to use the "RDS Query" component on the Matillion-hosted agent, but instead, you should be using the "Database Query" component.
Can you try this and let me know how you get on? It is an easy mistake to make, and you're certainly not the first to be caught out by it.
Thanks,
Johnathan
Hi Tharani,
instead of RDS try using "Database query" component,
choose database type: MariaDB
connection URL: jdbc:my....com/training
username: <given in course>
pass: create a secret (key the value as the password shared in the course), and store you pass in the secret then use the secret.
paste the SQL query in Configure.
Set a destination as a table_name as per tutorial.
Validate and check Sample data.