https://community.databricks.com/t5/data-engineering/how-to-retrieve-the-spark-statistics-createdat-when-statistics/m-p/127465#M47977 <P>Hello&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/166046">@Sainath368</a>!</P> <P>sql.statistics.createdAt reflects the epoch time when statistics were created. Unfortunately, there's no direct command available to check when the statistics were last updated.</P> <P>As a workaround, you can manually set the current timestamp as a custom table property right after running the ANALYZE command.</P> Tue, 05 Aug 2025 13:52:15 GMT Advika 2025-08-05T13:52:15Z https://community.databricks.com/t5/data-engineering/how-to-retrieve-the-spark-statistics-createdat-when-statistics/m-p/127327#M47924 <P>Hi everyone,</P><P>I regularly (once a week) run the analyze table compute statistics command on all my tables in Databricks to keep statistics up to date for query optimization.</P><P>In the Spark table UI catalog, I can see some statistics metadata like spark.statistics and spark.statistics.createdAt. However, when I query the table properties or use commands like describe table extended or check the table metadata programmatically, I can only retrieve statistics such as table size and row count — but not the&nbsp;spark.statistics.createdAt value indicating when the statistics were last computed.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sainath368_0-1754309683688.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/18707i2337340F1AAD183B/image-size/medium?v=v2&amp;px=400" role="button" title="Sainath368_0-1754309683688.png" alt="Sainath368_0-1754309683688.png" /></span></P><P>I need to store this updated time in another table . Could anyone suggest a reliable method or the right command to retrieve the exact time when statistics were last updated or created for a table in Databricks/Spark?</P><P>Thanks in advance!<BR /><BR /><BR /></P> Mon, 04 Aug 2025 12:20:43 GMT https://community.databricks.com/t5/data-engineering/how-to-retrieve-the-spark-statistics-createdat-when-statistics/m-p/127327#M47924 Sainath368 2025-08-04T12:20:43Z https://community.databricks.com/t5/data-engineering/how-to-retrieve-the-spark-statistics-createdat-when-statistics/m-p/127465#M47977 <P>Hello&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/166046">@Sainath368</a>!</P> <P>sql.statistics.createdAt reflects the epoch time when statistics were created. Unfortunately, there's no direct command available to check when the statistics were last updated.</P> <P>As a workaround, you can manually set the current timestamp as a custom table property right after running the ANALYZE command.</P> Tue, 05 Aug 2025 13:52:15 GMT https://community.databricks.com/t5/data-engineering/how-to-retrieve-the-spark-statistics-createdat-when-statistics/m-p/127465#M47977 Advika 2025-08-05T13:52:15Z