How to downsample data in AWS TimeStream

Question

I understand AWS TimeStream allows data to be moved to different types of storage based on retention period but we also need data to be downsampled based on retention period.

For e.g.

• 48 hours, one second granularity
• 30 days, one minute granularity
• 10 years, one hour granularity

How can this be achieved?

Answer 1

I don't think timestream currently supports that in storage. The nature of time-series databases is that you write once & change very very seldom. So by the intention behind it, this kind of granularity change you'd do in the query with for example the bin() function.