When a stream is used to update a target table, the offset is advanced to the current time. Snowflake streams record changes to a table, and using the stream to update the target table ensures that the offset progresses, reflecting that the changes up to that moment have been processed. This characteristic helps maintain data consistency and allows for efficient tracking of changes.