Can Snowflake Auto Purge records older than X number of days?

Question

For an existing table in snowflake is there a way we can set TTL for each record ?

In other words can i ensure records updated/created more than 90 days ago is automatically purged periodically.

score 3 · Answer 1 · answered Nov 19 '19 at 14:59

You can use a Snowflake TASK to run deletes on a routine schedule. And if you are dealing with a very large table, I recommend that you cluster it on the DATE of whatever field you are using to delete from. This will increase the performance of the delete statement. Unfortunately, there is no way to set this on a table and have it remove records automatically for you.

sridark · Accepted Answer · 2019-11-19T16:01:12.167

2

Opt 1. If the table is used for analytics, you can build a view on top of it to retrieve only last 90 days data (doing this you have the history) Opt 2. you can use SQL statement on schedule which deletes the records which are > 90 days

edited Nov 19 '19 at 16:01

answered Nov 19 '19 at 12:44

sridark

83
6

Can Snowflake Auto Purge records older than X number of days?

2 Answers2