Is there any way to get timestamp of last data refresh for a given VDS or any other metadata which will help identify if the vds was refreshed or not.
I think you mean reflections on a VDS? A VDS itself doesn’t have a last data refresh timestamp. EE and Cloud editions have nice UI for this in the reflection summary page. For CE, I think you can query the sys reflection and materialization tables: