The target table schema does not match the incoming file format, causing repeated COPY failures. The pipe accumulated a backlog of failed files that triggered Snowflake's auto-pause safeguard. The cloud notification queue credentials expired, causing repeated authentication failures. The stage referenced by the pipe was dropped or its permissions were revoked

Step 1: Check the pipe status: SELECT SYSTEM$PIPE_STATUS('pipe_name') to confirm it is paused and see the last error.. Step 2: Query COPY_HISTORY() to find which files failed and what error they returned.. Step 3: Fix the root cause (schema mismatch, file format issue, or permissions).. Step 4: Resume the pipe: ALTER PIPE pipe_name SET PIPE_EXECUTION_PAUSED = false.. Step 5: Use ALTER PIPE pipe_name REFRESH to reprocess any files that arrived while the pipe was paused.

High severityexecution

Power BI Refresh Error:
090164

What does this error mean?

Snowflake automatically paused a Snowpipe because it encountered repeated errors, preventing further auto-ingest events from being processed.

Common causes

1The target table schema does not match the incoming file format, causing repeated COPY failures
2The pipe accumulated a backlog of failed files that triggered Snowflake's auto-pause safeguard
3The cloud notification queue credentials expired, causing repeated authentication failures
4The stage referenced by the pipe was dropped or its permissions were revoked

How to fix it

1Step 1: Check the pipe status: SELECT SYSTEM$PIPE_STATUS('pipe_name') to confirm it is paused and see the last error.
2Step 2: Query COPY_HISTORY() to find which files failed and what error they returned.
3Step 3: Fix the root cause (schema mismatch, file format issue, or permissions).
4Step 4: Resume the pipe: ALTER PIPE pipe_name SET PIPE_EXECUTION_PAUSED = false.
5Step 5: Use ALTER PIPE pipe_name REFRESH to reprocess any files that arrived while the pipe was paused.

Frequently asked questions

Are files lost when Snowpipe is paused?

No — files in the cloud storage stage are not deleted when Snowpipe pauses. After fixing the issue and resuming the pipe, run ALTER PIPE pipe_name REFRESH to process files that arrived during the pause.

How do I prevent Snowpipe from auto-pausing?

Fix file format and schema issues before they cause repeated failures, and monitor COPY_HISTORY for file-level errors. There is no setting to disable auto-pause, as it protects against runaway failure loops.