Do the following steps on a periodic (e.g. daily or weekly) basis.
- Calculate usage: Calculate the number of users of a given asset (table, dashboard, etc.) and determine when that asset was last used.
- Manage lifecycle: Use this combination of metadata to manage the lifecycle of the asset.
- After 30 days without usage and less than 5 users, flag the asset as “Stale”.
- After 60 days without usage and less than 10 users, archive the asset.
- After 120 days without usage, purge the archived asset.
The specific timelines may vary by business, type of data, and regulatory requirements, but the process can be similar. Reinstating the asset should reset the “clock.”
Maintain a clean data landscape.
Clean up data landscape by removing duplicate assets
Prevent duplicate assets to reduce costs.
Dynamic data pipeline optimization
Reduce unnecessary data processing and improve resource utilization.
Allocate compute resources dynamically
Improve resource utilization and reduce processing delays.