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                  
 ....