'Adding TimeExpression to AWS SQL Query

I am using a DeltaTime filter to query an AWS IoT Analytics dataset, for the most recent entries from hundreds of sensors, but do not have any columns that can derive the time of the message. Is there any way to still filter the dataset using a DeltaTime SQL time expression, without deriving the timestamp from one of the columns?

delta time expression

AWS IoT Analytics Dashboard



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source