Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A Snowflake stream can become stale if its offset moves outside the data retention period for the source table/view.

Tip
Review the Snowflake document Avoiding Stream Staleness on how to avoid a stream becoming stale

A stale stream can be identified through the query history as shown in the example below

To un-stale a stream, simply rerun the create statement making sure that the grants to it are the same as prior to the recreation