how to display timestamp in epoch format using boto3 cloudwatch query ?

Question

Hi,

I'm tryin to display the log entry timestamp in epoch format using boto3 logs query function. 
Documentation instructs to use '`toMillis( @timestamp)`' , however 'toMillis( ) displays an floating-point number. eg: '`{'field': 'toMillis(@timestamp)', 'value': '1.701646365129E12}`'

The cloudwatch insights web console does permit timestamp conversion to epoch format using syntax '`fields @timestampEpoch as @timestamp`', however this syntax does not work for boto3 queries. Also, I cannot find any documentation on `@timestampEpoch`

Any suggestions  besides converting the format using `.time() ` python functions ?

thx

Answer

Hi,

I understand you have are trying to display the log entry timestamp in the epoch format using boto3 logs query function.

The following can be achieved by using the toMillis() function, however it would display the floating point number as you had shared.

The suitable method would be to use the .time() function in order to achieve this particular use case as I have not found any additional method of achieving this conversion. It was noted that the cloudwatch insights console does permit timestamp conversion to epoch format, however this similar syntax cannot be seen in the Boto3 documentation.

I am positive this helps. Let me know if you have any follow-up questions as we can keep this thread open for additional discussions with the community.

Kind regards, Muhammad

how to display timestamp in epoch format using boto3 cloudwatch query ?

Relevant content