A stream is a great way to track changes to a source table in #Snowflake. These tracked changes can then be used to create an incremental load for example.

There are 3 types of streams:

– Standard: tracks all data manipulation changes to an object.

– Append-only: tracks only inserts.

– Insert-only: tracks only inserts on external tables (data in an external stage) only.