Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

AWS S3 file properties

Hello,

 

I would like to know if there is a way to get file properties (like size, timestamp) of a file places in S3 bucket. 

 

I have tried the following but unable to get file size and timestamps. Also does this differ if the file in S3 bucket is .gz file.

 tS3 Connection

tS3FileList --iterate--> tFIleProperties --iterate--> tIterateToFlow --main--> tLogRow

Thanks,

A

Labels (2)
11 Replies
PhilHibbs
Creator II
Creator II

Additionally, all of the suggestions of "download the file and check the timestamp" are no use since the tS3Get component gives the file a timestamp of the time the download was done, it does not replicate the S3 timestamp of the file onto the local file.

PhilHibbs
Creator II
Creator II

SOLVED!

 

If your tS3List component is called, for example, tS3List_1, simply add the following entry to a Date column in the subsequent tIterateToFlow:

 

objectSummary_tS3List_1.getLastModified()

 

This is relying on undocumented internal variables. I have tested it in Talend v6.3 and 7.1. Another drawback is that if you copy and paste a pair of components, the globalMap.get("tS3List_1_CURRENT_KEY") call will be updated with the new component name, but the internal variable objectSummary_tS3List_1 will not be.