Timestream Data Writes which Unit? Calculate Ingestion Costs

Question

After a scheduled query in Timestream, we get the information about Data Writes
You can see the information [here](https://docs.aws.amazon.com/de_de/timestream/latest/developerguide/API_query_ExecutionStats.html)

It is described as:

> Data writes metered for records ingested in a single scheduled query run.

I try to calculate costs at the moment and I assumed that this is in Bytes. But my actual calculation vs. estimation doesn't really fit. Can you let me know which unit this is and how I would calculate the ingestion costs here for scheduled queries?

Thanks 😊

Answer

You're correct in your understanding. The "Data writes" metric displayed in Timestream after a scheduled query refers to the amount of data ingested in bytes. This metric helps you estimate the ingestion costs associated with your scheduled queries.

Here's how you can calculate the ingestion costs for scheduled queries in Timestream:
Gather Information:
1. Data Writes (Bytes): This value is available from the Timestream console or through the AWS SDK after a scheduled query run.
Timestream Pricing: Refer to the Timestream pricing page (https://aws.amazon.com/timestream/pricing/) for the current on-demand pricing per gigabyte of data ingested. As of April 18, 2024, the price is $0.0075 per GB.

Conversion and Calculation:

Convert Bytes to Gigabytes: Divide the "Data writes" value (in bytes) by 1,073,741,824 (1 Gigabyte in bytes). This will give you the data ingested in gigabytes.

Cost Calculation: Multiply the data ingested in gigabytes by the on-demand pricing per gigabyte.

Here's the formula:
Estimated Cost = (Data Writes in Bytes) / (1073741824 Bytes/GB) * ($0.0075 per GB)
Example:
Let's say your Timestream console shows "Data writes: 1024 bytes" after a scheduled query.
Convert bytes to gigabytes: 1024 bytes / 1073741824 bytes/GB = 0.00000095 GB (approximately)
Cost calculation: 0.00000095 GB * $0.0075/GB = $0.000007 (approximately)

Please note pricing also depends on Magnetic store or memory store . Also please be mindful of committed use discounts option, it will help bring down costs.

Timestream Data Writes which Unit? Calculate Ingestion Costs

Relevant content