Snowpipe Auto Ingest is supported only for external stages.

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

Snowpipe Auto Ingest is supported only for external stages.

Explanation:
Snowpipe Auto Ingest relies on cloud storage event notifications to trigger loads, and these notifications are available only when data lives in external stages tied to a cloud storage account. Internal stages are Snowflake-managed storage and do not emit external file events that Snowpipe can listen for, so auto-ingest cannot be triggered from them. Therefore, Snowpipe Auto Ingest is supported only for external stages — the setup requires an external stage (such as S3, Azure Blob, or Google Cloud Storage) with the appropriate storage notifications, and a Snowpipe pipe configured with AUTO_INGEST = TRUE. If you need to load from an internal stage, you would use other loading methods, not auto-ingest.

Snowpipe Auto Ingest relies on cloud storage event notifications to trigger loads, and these notifications are available only when data lives in external stages tied to a cloud storage account. Internal stages are Snowflake-managed storage and do not emit external file events that Snowpipe can listen for, so auto-ingest cannot be triggered from them. Therefore, Snowpipe Auto Ingest is supported only for external stages — the setup requires an external stage (such as S3, Azure Blob, or Google Cloud Storage) with the appropriate storage notifications, and a Snowpipe pipe configured with AUTO_INGEST = TRUE. If you need to load from an internal stage, you would use other loading methods, not auto-ingest.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy