Hi @balanarasimha c ,
Thanks for your posting.
You could get the latest update date from MDSCHEMA_CUBES rowset, please try below script:
SELECT CUBE_NAME AS [Cube/Perpective], LAST_DATA_UPDATE,* FROM $System.MDSCHEMA_CUBES WHERE LEFT(CUBE_NAME, 1) <> '$' ORDER BY LAST_DATA_UPDATE DESC ------- SELECT CUBE_NAME AS [Dimensions], LAST_DATA_UPDATE,* FROM $System.MDSCHEMA_CUBES WHERE LEFT(CUBE_NAME, 1) = '$' ORDER BY LAST_DATA_UPDATE DESC
Please note that the date and time provided are in UTC, you have to perform conversion to local time. Any process of a table or also a single partition of a table will reflect in an updated LAST_DATA_UPDATE. For more information, please refer to this thread and 184.108.40.206.220.127.116.11.1 Columns.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.