Hello
I am currently testing a setup on Dremio Cloud where we rely heavily on raw & aggregation reflections to speed up BI dashboards (especially with Power BI and Tableau). While the performance gains are great; I have started noticing a strange issue; some queries that normally use reflections intermittently fail with a vague âReflection not availableâ error; even though the reflection status shows as accelerated and healthy.
A simple retry often resolves it; but this is obviously not ideal for automated dashboards.
I have verified that the datasets havenât changed, the reflections have not been rebuilt recently & the jobs page doesnât show any reflection refresh conflicts. My suspicion is that something in Dremio Cloudâs internal caching or reflection routing logic might be causing temporary unavailability.
Has anyone else experienced this? I am curious if thereâs a best practice around staggering reflection refreshes / using fallback strategies to avoid this inconsistency.
If this sounds familiar or youâve solved something similar, I would love to hear your insights. In the meantime; I found this Dremio documentation on Reflection Refresh Best Practices that helped clarify how refresh timing works but it doesnât cover transient failures well. Since Dremio Cloud operates entirely in the cloud; itâs a great case study when explaining what Is Cloud Computing in real-world analytics workflows.
Any additional recommendations for stable use in production dashboards would be appreciated.
Thank you !!