CODEWITHSUNDEEP
snowflake-cloud-data-platform
user17902572
user17902572

Reputation: 11

Snowpipe getting auto paused and auto ingestion not working

I am using snowpipe to auto ingest data into raw tables. I am using auto_ingest=true as well but the data is not getting loaded as expected. On further checking, found that the respective snowpipe is in paused state. However, I have not manually paused the pipes. Has anyone faced this issue? or any suggestions on how can I troubleshoot to find out the cause why pipe is getting paused on its own.

Upvotes: 1

Views: 496

Answers (1)

Sachin Mittal
Sachin Mittal

Reputation: 21

Mostly this issue comes when you clone the Source DB to newer one, CLONING the Database makes the PIPE in STOPPED State in cloned DB. So to make PIPE running in the CLONE DB, we need to execute the below command: ALTER PIPE mypipe SET PIPE_EXECUTION_PAUSED = FALSE

Upvotes: 1

Related Questions