Reflections failing

Raw Reflections created on a dataset by specifying partition & sort field, then the job completes but the footprints shows faiiled after refreshing the VDS…

Hi Victor, can you post the “REFRESH REFLECTION” job profile? There’s a bunch of sys tables like sys.reflections and sys.materializations that you can also query to troubleshoot.

Hello Benny, thank you for your response but the issue seems to have been solved after upgrading to 22.4.1 from 22.3.1 now reflections are monitored with no failures in the last 72hrs, so seems the issue was with the old version which is resolved in the updated version.

1 Like