Snowflake Error:
100132
What does this error mean?
A Snowflake Task failed during scheduled or manual execution — this is a task-level wrapper error, meaning the root cause lives inside the task's SQL body or stored procedure and must be investigated there. Check the task run history for the underlying error message.
Common causes
- 1The SQL or stored procedure called by the task contains a runtime error (permission denial, object not found, syntax error)
- 2A predecessor task in the DAG failed, causing dependent tasks to be skipped or fail
- 3The task's WAREHOUSE is suspended and auto-resume is disabled
- 4The task owner role no longer has the required privileges on objects referenced in the task body
- 5The task ran longer than its scheduled interval, causing an overlap conflict
How to fix it
- 1Check task run history: SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY(TASK_NAME => 'my_task')) ORDER BY SCHEDULED_TIME DESC.
- 2Inspect the ERROR_MESSAGE column in TASK_HISTORY for the underlying SQL error.
- 3Resume the task if it is suspended by running: `ALTER TASK mydb.myschema.my_task RESUME`.
- 4Verify the task owner role's privileges: SHOW GRANTS TO ROLE task_owner_role.
- 5If a predecessor task failed, address that failure first — dependent tasks will not run until the DAG root succeeds.
- 6Increase the task schedule interval or optimize the task SQL to prevent run-time overlap.