View full changelog

Understand Data Freshness and Row Count Changes

Date
  • Adam Wisniewski
    Software Engineer at SELECT

SELECT users can now easily monitor freshness and row count changes across all their tables, with 365 days of history. This is helpful for understanding data update patterns, along with diagnosing operational issues like job failures which lead to stale data.

For the table shown below, you can see that it updates once per day with about 350K rows each time. The data freshness typically stays under 24 hours, but on October 4 you can see there were no table updates (perhaps the job failed), and therefore the data is nearly 2 days stale.

Understand Snowflake table row count changes and data freshess

Get up and running with SELECT in 15 minutes.

Snowflake optimization & cost management platform

Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.

SELECT web application screenshot

Want to get notified when we release new features? 
Subscribe to get notified.