SQL command to Refresh Reflection

1

Hello
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) ?

2

@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

1 Like
3

@balaji.ramaswamy, good morning, for me this step by step that you passed worked, thank you.
But via api or some command by the sql editor can have the same result? greetings

4

@Gerbasi You can use the Catalog Refresh API to refresh dependent reflections of a physical dataset. You need the id of the PDS as the input. See: Dremio

2 Likes