We see Dremio uses following sequence to refresh REFLECTION (REFRESH REFLECTION AS , LOAD MATERIALIZATION METADATA , DROP TABLE IF EXISTS “____accelerator”.…).
When trying to run those commands through UI we get an error message, how to refresh REFLECTION without using the GUI ? (only through SQL or API) ?
@Arnie These are internal jobs that Dremio creates and will not work via the SQL editor. To refresh the reflection via the UI hit “refresh now” on the physical dataset. If your VDS is a join of more than one PDS, then pick any one in the chain and hit “refresh now”, Dremio will make sure to refresh the dependent PDS, click on settings on the PDS and “Refresh Now” should be under the reflections tab