AWS Timestream - Delete/Mutate record

0

I'm using boto3/python to try and update a record via 'write_records(...)'. In response I get 'A record already exists with the same time, dimensions, and measure name. Updating measure value is not supported.' There is no boto3 api to delete or update a record.

Is there anyway to either delete a record or mutate a record? I'm storing user data and would like to delete user data upon a GDPR request.

I get the feeling that a record is immutable by design however the documentation doesn't say it is, at least that I could find.

Edited by: Whale on Oct 8, 2020 10:36 PM

Whale
asked 4 years ago2125 views
3 Answers
0

In this video(Getting started with Amazon Timestream) they say you can only append to the table https://aws.amazon.com/timestream/getting-started/?nc=sn&loc=4
Also, abstract from docs https://docs.aws.amazon.com/timestream/latest/developerguide/API_WriteRecords.html :
"RejectedRecordsException
WriteRecords would throw this exception in the following cases:

  • Records with duplicate data where there are multiple records with the same dimensions, timestamps, and measure names but different measure values."
katoo
answered 4 years ago
0

Thanks for reaching out. Amazon Timestream currently does not support deleting and updating of existing records. We will add this feature asks to our list of feature requests.

Thanks for your interest and support for Amazon Timestream.

AWS
answered 3 years ago
0

As of 11/24 Amazon Timestream supports the ability to upsert records. Please see https://docs.aws.amazon.com/timestream/latest/developerguide/getting-started.java-v1.code-samples.write-to-table.html for details.

AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions