What're the different types of Analytical View states and what do they mean?

Hi Tadd,

Is there any way to find out when exactly and at what time AV’s went to a stale mode?

@Purnesh it’s usually due to DDL operations on the base/source table. You can look at the “describe formatted xxtablename” to get the last DDL update on the table which would be indicative of the staleness of the Analytical View.

 | spark.sql.sources.schema.partCol.0                 | deposit_date            | 
 |` transient_lastDdlTime                              | 1567002768               | `
 | # Storage Information         | NULL                                               | NULL