I am currently going through the Matillion Academy training courses, and I'm having issues with one of the s3 buckets needed to continue.
The bucket in question is s3://online-mtln-training-s3-flights/
I am receiving the message:
The specified bucket does not exist (Service: Amazon S3; Status Code: 404; Error Code: NoSuchBucket; Request ID: 9R6PSYFNV9PB8MRN; S3 Extended Request ID: R5VB5odCuPLbDyQT8Pdt7WYRSAVOQ4DJMzlQNrwozJzmIrIoM/LdEb1yyfnhlHk4tOufkQFaVXA=; Proxy: null)
Has the bucket since been renamed, and the notes just weren't updated?
Hi @drock1635272309580
I have seen this question before, the answer can be found here:
https://matillioncommunity.discourse.group/t/s3-bucket-files-for-training-not-public/1397
Let me know if that helps :)
Kind regards, Joe
I am unable to run the S3 load component. Errors says: "SQL compilation error:
Object does not exist, or operation cannot be performed." Any suggestions?
Hi there @vijaya.c.sharma, thanks for your post.
Your error seems to be related to a SQL syntax you have in your job. It doesn't necessarily has be related to the S3 Load component. Please try checking the specific component where you are getting the error and review your SQL query.
Let us know if that helps at all!
Many thanks,
Claire
Actually i don't have any SQL written in the job. I am running the specific S3 load component, not the whole job and so i know that the error occurs there. You can refer the below screenshot.
Hi @vijaya.c.sharma and thanks for the response!
I'm afraid we need some more information to debug the error that you're seeing. The error seems related to a problem for uploading the data into the "training_flights" table created on the previous Create Table component. Any extra information you can give us would be appreciated.
Many thanks,
Claire
