Answer: INSERT, DELETE

The METADATA$ACTION column in a Snowflake stream indicates the type of DML operation that was performed on the source table. According to Snowflake documentation and the community consensus (with AC having 67% support and the most upvotes), the possible values are 'INSERT' and 'DELETE'. 'INSERT' represents new rows added to the table, while 'DELETE' represents rows removed from the table. 'UPDATE' operations are not directly recorded in METADATA$ACTION; instead, an UPDATE appears as a DELETE of the old row and an INSERT of the new row. 'TRUNCATE' is not a value in METADATA$ACTION but clears the stream. 'UPSERT' is not a standard DML operation in Snowflake streams and thus not a valid value for METADATA$ACTION.

Author: LeetQuiz Editorial Team