@Werner Stinckens​  if i keep anything in one container how does that support batch and real time analytics ?

Example : i have a container with delta table which has 2 years of data that supports BI reporting for historical data.

if i use same delta table how does that supports real time it unnecessary scans all 2 years data which is not needed and would definitely hamper performance.

to support real time i need have 1 or 2 days worth of data right ?

are you getting what i am addressing here ?