Does Snowflake insert “OVERWRITE” impact how STREAMs capture changes

Question

insert OVERWRITE into table1 
select * from table2 where City = SFO 

I noticed that Snowflake STREAM captured all rows of the table instead of just City=SFO

Any thoughts?

Answer 1

insert overwrite deletes all rows from table1 , so the stream is capturing all deleted rows plus the inserted rows in table 1 with city=SFO from table2.