QuestionQ15

VerifiedImplement Snowflake data science best practices

A Data Scientist is developing a data pipeline for a customer churn model. To support efficient processing of the model, they add a stream to the customer table.

Which function should be used to determine whether the stream contains new or updated data?

Explanation

Snowflake's SYSTEM$STREAM_HAS_DATA function indicates whether a specified stream contains change data capture (CDC) records, allowing processing to run only when the stream has unconsumed changes.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!