- Streams provide things like:
- METADATA$ACTION (whether a change was an insert, delete, etc.)
- METADATA$ROWID (to identify rows across changes)
- METADATA$ISUPDATE flag or similar to check if the changed row is an update vs just a change in value.
This metadata helps in merging efficiently into downstream tables and applying logic depending on type of change.
