The following DDL statement created a task based on a stream:
Assuming MY_WH is configured with auto_suspend = 60 and is used solely for this task, which statement is true?
MY_WH
auto_suspend = 60
A scheduled task evaluates SYSTEM$STREAM_HAS_DATA('MYSTREAM') before executing. If the stream has no change data, the run is skipped without starting the user-managed warehouse; the WHEN validation is processed by Snowflake’s cloud services layer. Therefore, MY_WH is active only when the stream condition permits the task to execute. Snowflake CREATE TASK documentation
SYSTEM$STREAM_HAS_DATA('MYSTREAM')
WHEN
Community Discussion