Which of the following is NOT an additional column in the stream output?

• A. METADATA$ACTION
• B. METADATA$ROW_NUMBER
• C. METADATA$ROW_ID
• D. METADATA$ISUPDATE

Answer: (B)

In Snowflake streams, each changed row is returned with a set of metadata columns that describe what happened to that row. The standard metadata includes an indicator of the operation (METADATA$ACTION), a stable identifier for the row across changes (METADATA$ROW_ID), and a flag showing whether the row is part of an update (METADATA$ISUPDATE). There isn’t a built-in metadata column for row numbering in the stream output; ROW_NUMBER is a window function you’d apply in downstream queries if you need ordering, not a provided stream metadata column. Therefore, METADATA$ROW_NUMBER is not included in the stream output.