SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ85

Implement Data Pipelines

A Data Engineer is creating a data pipeline to ingest incremental data from a data source by using streams and tasks in Snowflake. A stream is created on a CUSTOMER_RAW table to track new records and merge them into a CUSTOMER master table through a task that runs every hour.

What happens if the CUSTOMER_RAW table is renamed to CUSTOMER_BASE after the task has run for three days?

Explanation

Renaming a stream’s source object does not break the stream or cause it to become stale. The stream continues to track the renamed table, and a task that consumes that unchanged stream can continue to run without disruption. Stream staleness is associated with retention and consumption timing, not a source-table rename.

Learn more

Community Discussion

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