Excel Query Component - Is it possible to use a subdirectory in the S3 Staging Area parameter?

Matillion ETL
1

We've just updated Matillion to 1.75 and it seems that the Excel Query Component is not working as before (v1.68).

 

In the S3 Staging Area we were able to put a subdirectory in a S3 bucket, like s3-shore-prddatammh/my/awesome/directory/ and it's not possible anymore.

 

We get this error now : Bucket s3-shore-prddatammh/my/awesome/directory/ not found

2

Hi @jocelyn.nourry​ could please explain it little clearly whether it is a "Storage URL" or "S3 staging" I think will get you answer.

3

Hello.

The issue is on the S3 Staging Area (the location of the temporary directory where the component creates and deletes temporary files).

4

@jocelyn.nourry​ don't use full path of S3 only use the bucket name, I think will help you.