@Werner Stinckens​  why i would do that ? rather i will prefer storing the tables in two containers one supports for real time which holds only one day worth of data and one more container which will hold all historical data.

This way can we not make BI work? that supports real time analytics and historical needs of data for reporting?

Please consider of connecting traditional BI tool to modern data platform i.e Databricks .