Experiencing issue in accessing the s3 URL. when i enter the s3 URL, i get an error "That URL does not point to an accessible S3 bucket." Not sure what's the issue with the URL, i have copied the link from my s3 bucket. I had with different format of the URL but none of them works.
I was trying to use the s3Load tansform for loading data from s3 to redshift. I am entered the URL in the s3 URL location property of the s3load transform.
In the “S3 URL Location” property of the S3 Load component, you should be able to enter a bucket name in the format:
optionally with a folder, like this:
If it’s not validating, could you please check that you have set up your Matillion instance’s AWS privileges as described here. This setup gives your Matillion EC2 instance the privilege to access your S3 buckets, among other things.
If you did not originally associate an AWS IAM Role to your instance, please follow the instructions here to do so.
As noted during our screen-share session, the AWS account you were using does not have access to the necessary services and hence the issue.
Your instance already has an IAM Role associated with it with sufficient privileges. Please continue to use “Instance Credentials” and everything will work as expected.