Hey guys, I’m using Table for DynamoDB and want to setup TTL of 30 days. How to do this with SST/CDK?

/**
     * The name of TTL attribute.
     *
     * @default - TTL is disabled
     * @stability stable
     */
    readonly timeToLiveAttribute?: string;

What should be the value?

It's whatever property in your data structure contains a Unix timestamp.

Yeah just found that out.

I set mine to "_ttl", and then when I write an item to the DB set it to

new Date().getTime() / MillisecondsInSecond

Nice!

Oh, plus something. That would expire the moment it is added. 😄

Hahaha yeah.

Oh, and Math.floor() it to avoid decimal places - don't know what would happen. Here's a more complete clip.

const now = new Date();
    const historySeconds = (await this.historyDays.get()) * SecondsInDay;
    const ttl = Math.floor(now.getTime() / MillisecondsInSecond) + historySeconds;

+1 to everything @Adam Fanello said, but I use

expiresAt

. I also recommend the lib

ms

to easily add time.

Awesome guys! thank you very much.

There is a caveat that is worth mentioning (and if you all already know please disregard): An item doesn't get purged immediately after the TTL has expired. It could take up to 48 hours (though I've typically seen within one hour). This means expired entries will still be returned in results. So if you want to exclude them, be sure to filter them out