Got it. Looking at the profile, not sure what’s causing the other reflection not to get matched, we’ll need to investigate further.
We’re working on a few things to make navigating between datasets, reflections and materializations easy. For now, you can use this query (which uses old acceleration vocabulary: layout = reflection):
select * from sys.layouts a join sys.accelerations l on a."acceleration_id" = l."acceleration_id"
Thanks a lot for this query that enables me to have metadata information on reflections !
I also have a straight forward UNION ALL query between two datasets which both have Raw reflections and the Raw reflection building for the union query does not use the reflections of the two datasets that were being unioned.
This seems challenging because we have to union many different data sets together and if the reflections are not used then our ability to query with dremio is sufficiently hampered.