LAST_ALTERED column from .information_schema.tables will capture any DML change(data refresh) happened to the tables refer: community.snowflake.com/s/article/Column-LAST-ALTERED-in-TABLES-view-gets-updated-when-a-query-attempts-to-update-the-tale-without-updating-any-rows Thanks.
how to find that, when table is last refresh in snowflake for tables without date field
LAST_ALTERED column from .information_schema.tables will capture any DML change(data refresh) happened to the tables
refer: community.snowflake.com/s/article/Column-LAST-ALTERED-in-TABLES-view-gets-updated-when-a-query-attempts-to-update-the-tale-without-updating-any-rows
Thanks.
@@snowbundle thanks for your inputs🙏 you r doing great job keep it up 👍