SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ95

Data Ingestion and Data Preparation

An Architect is designing a file-ingestion recovery solution. The project will use a named internal stage for file storage. At present, when an ingestion fails, the Operations team must manually download the failed file and inspect it for errors.

Which download method should the Architect recommend to require the least operational overhead?

Explanation

SnowSQL can run the GET command to download files from a named internal stage directly to a local directory, using Snowflake’s built-in staging transfer mechanism. GET cannot be executed from the Worksheets page in Snowflake web interfaces, while custom connector or API solutions add implementation and maintenance overhead.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!