Data lake lifecycle dry-run calculator

Calculate would transition IDs and would delete-review IDs with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use would transition IDs and would delete-review IDs to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

JSON Objects [ID,age days,size GB]
[["A",10,5],["B",40,20],["C",100,30]]
Supplied cold-transition age (days)
30
Supplied deletion-review age (days)
90
Would transition IDs
["B"]
Would delete-review IDs
["C"]
Transition volume (GB)
20
Deletion-review volume (GB)
30

Try another scenario

JSON Objects [ID,age days,size GB]
[["A",10,5],["B",40,20],["C",100,30]]
Supplied cold-transition age (days)
30
Supplied deletion-review age (days)
120
Would transition IDs
["B","C"]
Would delete-review IDs
[]
Transition volume (GB)
50
Deletion-review volume (GB)
0
Calculation method

Calculation method

Would transition IDs

J([r[0] for r in a if b<=r[1]<c])

Would delete-review IDs

J([r[0] for r in a if r[1]>=c])

Transition volume (GB)

sum(r[2] for r in a if b<=r[1]<c)

Deletion-review volume (GB)

sum(r[2] for r in a if r[1]>=c)

Symbols and units
a
JSON Objects [ID,age days,size GB]
b
Supplied cold-transition age (days)
c
Supplied deletion-review age (days)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Calculation steps and notation

sum(list) adds all entries in the list.

Assumptions & limits

Assumptions & limits

  • Read-only policy dry run; 0≤transition age<delete-review age. Objects may have external holds, which must exclude them before input. No actual deletion or legal retention claim. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.