go.chromium.org/luci@v0.0.0-20240309015107-7cdc2e660f33/resultdb/script/sql/spanner/2022-02-07-add-ttl-policy.sql (about)

     1  -- Add TTL to ResultDB Spanner database based on the data retention
     2  -- (go/resultdb#data-retention) and the proposal (go/resultdb-database-ttl).
     3  
     4  -- Add TTL for 1.5 years to Invocations table. The row deletion policy
     5  -- configured in the parent table will also take effect on the interleaved child
     6  -- tables (Artifacts, IncludedInvocations, TestExonerations, TestResults,
     7  -- TestResultCounts).
     8  ALTER TABLE Invocations
     9      ADD ROW DELETION POLICY (OLDER_THAN(CreateTime, INTERVAL 540 DAY));