Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?

Tasks may optionally use table streams to provide a convenient way to continuously process new or changed data. A task can transform new or changed rows that a stream surfaces. Each time a task is scheduled to run, it can verify whether a stream contains change data for a table and either consume the change data or skip the current run if no change data exists.

Which System Function can be used by Data engineer to verify whether a stream contains changed data for a table?
A . SYSTEM$STREAM_HAS_CHANGE_DATA
B . SYSTEM$STREAM_CDC_DATA
C . SYSTEM$STREAM_HAS_DATA
D . SYSTEM$STREAM_DELTA_DATA

View Answer

Answer: A

Explanation:

The SYSTEM$STREAM_HAS_CHANGE_DATA function is used to check if there is any change data available in a specified stream. If the stream has data, the function will return TRUE; otherwise, it will return FALSE. This is useful when combined with tasks to decide whether or not to execute a transformation or processing based on the presence of new change data in the stream.