Question 370
An organization running Snowflake reports: Two independent jobs rely on one stream and the second job finds no changes after the first consumes them in a DML transaction. Which Snowflake approach is most appropriate for this condition?
Explanation
Correct Answer
The root issue is that stream offsets advance when changes are consumed by qualifying transactions. The selected fix targets that condition: Provide independent streams or coordinated consumption for independent downstream consumers. Validate it by checking this outcome: Both downstream jobs receive their required source changes without offset contention.
Incorrect Answers
This action targets unloading to cloud stage, where the command targets table ingestion rather than the supported unload-to-stage operation. In the given incident, the decisive issue is instead that stream offsets advance when changes are consumed by qualifying transactions.
This action targets stream change capture, where the pipeline has no reliable changed-row tracking between processing transactions. The corrective response here is “Provide independent streams or coordinated consumption for independent downstream consumers”; this alternative does not provide that response.
This action targets task scheduled transform, where a newly created task may be suspended and not available for scheduled execution. The stem reports two independent jobs rely on one stream and the second job finds no changes after the first consumes them in a DML transaction; this control addresses a different failure condition.