Hi Dremio Team,
I am trying the following use case
created a raw reflection PD
created a helper VD as select * from PD where <date_col> = <FIxed_date>
created raw reflection on VD
now if i do select * from PD where <date_col> = <FIxed_date> (same date used in VD def)
its not using reflection on VD,
from the profile it says reflection on VD chosen, but not matched. Is there a way to implement this ?
my PD will have years of data, so it would be beneficial if we can make use of VD reflection for daily reporting.