I use Dremio to connect to a MongoDB fro Power BI report and am getting quite a few discrepancies while comparing the report to the original data source. I am wondering whether there is anyway that I can check when the data in Dremio is refreshed. According to the data source configuration, it is refreshing hourly. But is there anyway to see the exact time?
From the UI: go to the jobs page, and then Select only Accelerator jobs (it’s the second pull down from the 3 pull downs above the list of jobs). Then look for all jobs that have REFRESH REFLECTION as part of their query. Select that job and it will tell you the details of that reflection in the summary page.
All this information is stored in system tables. From a new query, you can run SELECT * FROM sys.refreshes
Note that the refresh only applies to Data Reflections. Your query will either be pushed down into mongo, or accelerated to use a reflection. If you look at your jobs you can see whether the query was accelerated.
If you are seeing discrepancies and the query is not being accelerated, then something else may be going on.