Which function can a task use to see whether a stream contains change data for a table?

• A. SYSTEM$STREAM_HAS_DATA
• B. SYSTEM#STREAM_HAS_DATA
• C. SYSTEM_HAS_STREAM_DATA
• D. STREAM_HAS_DATA

Answer: (A)

When you want to know if there are changes to process from a stream, use the built-in function that returns a boolean indicating whether the stream has data to read. This function takes the stream as input and returns TRUE if there are change rows (inserts, updates, deletes) since the last consumption, and FALSE if the stream is empty of new changes. It’s perfect for gating ETL steps, so you only run loading logic when there’s actual change data to process. You’d typically call it in a task WHEN clause or in a stored procedure with an IF, passing the fully qualified stream name (like database.schema.stream). Remember, a stream advances its offset when you read from it, so the result reflects whether there’s new data since the previous read. The other option names aren’t valid Snowflake system functions.