Amazon Timestream: Is there a cost associated with empty measure values?

0

If I have multi-measure records where most of the measures are empty, does that still affect my storage cost as if they were populated?

Example: Will a multi-measure record of 250 empty values and 2 populated values take up storage cost for 252 values or 2 values?

Also, if I have single-measure records with different data types, does the unused measure value have a cost to it?

Example: "measure_name='my_bigint', measure_value::double=NULL, measure_value::bigint=5000", does the NULL take up 8 bytes of storage?

已提问 2 年前730 查看次数
2 回答
2
已接受的回答

Since we do not support NULL values on ingest, if an ingested record does not include a measure either in a single measure or multi measure record, then it will not be charged for storage. The storage cost is associated with the measures, dimensions and values in the ingested record.

AWS
已回答 2 年前
1

This page (https://aws.amazon.com/timestream/pricing/) explains how pricing works for Timestream and provides some examples of billing. Based on that doc, billing is based in part on amount stored in GB. I don't know for sure whether or not NULL takes up 8 bytes of storage. This page (https://docs.aws.amazon.com/timestream/latest/developerguide/metering-and-pricing.storage.html) shows how to calculate the size of each record. The doc says 8 bytes for values. It also shows that each dimension consumes a number of bytes to hold the dimension name. According to the Supported data types documentation, null data is contained in the 'unknown' data type. So NULL is a valid datatype. Based on all that, I going to assume storing 252 values, regardless of values, is going to require more memory in storage than 2 values due to the increased size of every record containing 252 dimensions.

profile pictureAWS
Chris_P
已回答 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则