Staging bucket is not visible

Matillion ETL
1

I am trying to connect to Amazon Redshift as a destination. I have the credentials added and tested. When I reach configuration tab in Tasks, staging bucket field does not show any values. It throws error. There should be a bucket visible since the user has access to it via bucket policy.

 

0694G00000GGI3YQAX_0D54G00007tfhjySAA
0694G00000GGI3YQAX_0D54G00007tfhjySAA853×370 28.6 KB

2

The bucket is kept as private, but the user is given access using bucket policy.

0694G00000GGI9sQAH_0D74G000007jfHaSAI
0694G00000GGI9sQAH_0D74G000007jfHaSAI981×750 87.9 KB

3

Hi @MA414857​,

Have you granted your Matillion instance the s3:ListAllMyBuckets privilege? Matillion ETL uses that to generate the values for the dropdown list. Please see this document for a list and description of the fine grained IAM privileges that Matillion ETL can use.

Best regards,

Ian