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.
Hello, I tried your suggestion, but I am getting the following error:
‘The driver for the selected database type does not accept this URL.’
Hi @kklotzle
Thank you for your post, I have raised this with the Academy team, I will share an update as soon as I have one.
Kind regards, Joe
Hello Joe, let me know if I can provide anything like a screenshot to be more clear. I’ve tried with both an RDS and Database Query component, and I just can’t get anywhere.
Anything Like that would be most helpful, I have chased this morning with our team on this also.
Thanks Joe
Hello Joe, I don’t suppose there’s any chance of getting an extension on my free trial? I only have 6 days left and haven’t been able to move forward in the training due to this issue.
Hi @kklotzle
Josh here, from the Academy team.
Please can you clarify which course and module you are taking that is giving you that error?
Hello Josh,
Building a Data Warehouse, Level 1, Section 1, Stage Airports Data Using the RDS Query Component. I actually just tried to login to my free trial account, and I can’t even do that any more it appears. I just get the 4 shapes spinning forever when I click Log In. If you can help me, fine, but if not, that’s fine too. I was hoping to walk through the tutorial building it myself in my own workspace.
Hi @kklotzle
I will allow @josh to continue support with the academy side of things. With regards to your hub access, I can look into this, as you had previously mentioned, you encountered that issue when using a free email address (Example: Gmail) I assume you are using a work email address now and this issue has reoccurred?
Thanks Joe
Yes, Joe, thanks. My account was good to go, so I don’t know what happened. Maybe I need to close all my browsers and try again. I just don’t have the time at the moment.
Thanks @kklotzle
I want to help investigate this, I am going to send you a private message to get spme information.
Kind regards, Joe
hello, josh, here is a screenshot of what i am working with. i saw a link that said to try the same thing with a ‘Database Query’ object instead of the ‘RDS Query’, but i couldn’t get that to work either. the screenshot should show all the parameters I am using, which I’m positive match what is in the tutorial/training exercise. thanks for any help.
Hi @kklotzle, The course you are following (Building a Data Warehouse) is for MatillionETL, apologies if this isn’t clear I will rectify this. If you wish to follow along in The Data Productivity Cloud (as per the screenshot), please use the following Academy Course called Matillion Essentials
Hello Josh,
Thanks so much, but help me understand a little bit. So the MatillionETL is kind of just a follow-along where you just click as they tell you to click, whereas the Matillion Essentials you are actually building using the tool? I’m not quite clear. Thanks for your patience.
Matillion ETL is Matillion’s original, standalone ETL tool that you deploy and manage yourself to build and run data pipelines.
Matillion Data Productivity Cloud is Matillion’s newer SaaS platform version of Matillion ETL.
There are separate courses available for each product, so you can learn Matillion ETL specifically by doing the Building a Data Warehouse Course, or you can learn the Data Productivity Cloud by doing the Matillion Essentials course.
You can follow along in either courses in your own instance, but I am not sure if trials are available at the moment for Matillion ETL. Trials are available for the Data Productivity Cloud though.
1 Like
Thanks for the explanation, Josh. So I would assume since I’m a beginner, maybe there’s not as much incentive to learn Matillion ETL as there is Matillion DP Cloud. Is that safe to say? Thanks for your time! Sorry to take so much of it.
We strongly encourage new users to start learning in the Data Productivity Cloud.
Any time, let me know if you have anymore questions.
