An Architect is designing a file ingestion recovery solution. The project will use an internal named stage for file storage. Currently, in the case of an ingestion failure, the Operations team must ma

Question

Options

• AUse the Snowflake Connector for Python, connect to remote storage and download the file.
• BUse the get command in SnowSQL to retrieve the file.
• CUse the get command in Snowsight to retrieve the file.
• DUse the Snowflake API endpoint and download the file.

• A
  21% (7)
• B
  68% (23)
• C
  9% (3)
• D
  3% (1)

Explanation

SnowSQL is Snowflake's official CLI client, and its GET command is specifically designed to download files from internal named stages to a local directory. It requires no additional setup beyond the existing SnowSQL installation and handles the download natively, making it the lowest-overhead solution. Option A (Python Connector) requires writing and maintaining custom code to connect to remote storage. Option C is incorrect because Snowsight (the Snowflake web UI) does not support a GET command for downloading files from internal stages. Option D (REST API) requires constructing and managing API calls, adding significant operational complexity compared to a simple SnowSQL command.

No community discussion yet for this question.