How can we improve Azure Storage?

Have a TTL on Table Storage rows, so temporary data gets deleted

Say you are storing details about logs / orders / page views. You may not care about them after 2 weeks / 1 month / 1 year.

To save money it would be great to have a job run daily that deletes this data when it is deemed out of data by the system designer.

AWS has this in DynamoDB where you create a column for an expiration date on tables that will accumulate data that might be temporary by nature. When you create a row you populate this column with the timestamp in the future you want this deleted. AWS then runs a job periodically to delete those rows where the expirary date is in the past - you are not charged for data older than the expiry date http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/TTL.html

135 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
Colin Farr shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Eric commented  ·   ·  Flag as inappropriate

    Cosmos DB as the TTL feature: would it be possible for Microsoft to 'recycle' the feature to Azure Table, even if they are conceptually very different (Cosmos DB is a full NoSQL DB) ?

Feedback and Knowledge Base