SnowPro Associate: Platform Question 192
Single answer● StagesA data engineering team loads daily CSV files from an Amazon S3 bucket into Snowflake. They want to simplify the loading process so analysts can run COPY INTO statements without repeatedly specifying cloud credentials or file format settings. The team also wants to limit accidental use of the wrong bucket path. Which Snowflake object should they create to best meet these requirements?
- A
An external stage that stores the S3 URL, credentials or storage integration, and file format definition
- B
An internal named stage and then use PUT to upload the files from S3 into Snowflake
- C
A temporary stage created in each analyst session with the S3 bucket URL and file format
- D
A table stage on the target table, because table stages automatically inherit cloud storage credentials
Show answer and explanation
Correct answer: A
Explanation
The best solution is to create an external stage. In Snowflake, stages are named database objects that reference data files for loading and unloading. External stages point to cloud storage locations such as Amazon S3, Google Cloud Storage, or Azure Blob Storage. They can store the URL, authentication mechanism, and file format, which simplifies COPY INTO usage and improves consistency. In practice, Snowflake recommends using a storage integration instead of embedding cloud credentials directly when possible. Internal stages, including named stages, table stages, and user stages, store files within Snowflake-managed storage and are used with commands such as PUT and GET. Because the requirement is to load directly from S3 while reusing configuration and constraining the bucket path, an external stage is the correct choice.
- A. Correct.
Correct. An external stage is designed to reference files in external cloud storage such as Amazon S3. It can encapsulate the storage location, access method (credentials or, preferably, a storage integration), and optional file format. This reduces repetition in COPY INTO commands and helps control which bucket path users load from by pointing them to a predefined stage.
- B. Incorrect.
Incorrect. An internal named stage stores files inside Snowflake, not in S3. The PUT command uploads files from a local client machine to an internal stage; it is not used to transfer files directly from S3 into Snowflake. This option reflects a common confusion between internal and external stages.
- C. Incorrect.
Incorrect. Temporary stages are session-scoped and not appropriate for a shared, repeatable loading pattern used by multiple analysts. While a temporary stage could reduce typing in one session, it would not provide durable configuration or centralized control over the approved S3 path.
- D. Incorrect.
Incorrect. A table stage is an internal stage associated with a specific table. It does not automatically connect to external cloud storage or inherit S3 credentials. This option confuses internal table stages with external stages.