METADATA$ROW_ID: Specifies the unique and immutable ID for the row, which can be used to track changes to specific rows over time.

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

Answer: (A)

In Snowflake streams, rows carry special metadata that describes how they changed. METADATA$ROW_ID is the unique, immutable identifier assigned to each logical row. Because this ID doesn’t change as the row is updated or reformatted in subsequent stream outputs, you can reliably track all changes to the same row over time, linking its before/after versions and understanding its full history.

This makes METADATA$ROW_ID the best choice for tracking a specific row across changes. Other metadata fields describe the nature of the change (for example, what action occurred) or provide a positional flag, but they don’t offer a stable, persistent identity for the row.