COF-C02 · Question #393
Which file function gives a user or application access to download unstructured data from a Snowflake stage?
The correct answer is C. GET_PRESIGNED_URL. GET_PRESIGNED_URL generates a temporary, pre-signed URL that allows anyone (including external users and applications) to download a specific file from a Snowflake stage without needing Snowflake credentials or an active session. This makes it ideal for distributing…
Question
Which file function gives a user or application access to download unstructured data from a Snowflake stage?
Options
- ABUILD_SCOPED_FILE_URL
- BBUILD_STAGE_FILE_URL
- CGET_PRESIGNED_URL
- DGET STAGE LOCATION
How the community answered
(54 responses)- A2% (1)
- B4% (2)
- C93% (50)
- D2% (1)
Explanation
GET_PRESIGNED_URL generates a temporary, pre-signed URL that allows anyone (including external users and applications) to download a specific file from a Snowflake stage without needing Snowflake credentials or an active session. This makes it ideal for distributing unstructured data. BUILD_STAGE_FILE_URL requires Snowflake authentication to use, BUILD_SCOPED_FILE_URL is session-scoped and not suitable for external sharing, and GET_STAGE_LOCATION returns only the base location of a stage rather than a downloadable link to a specific file.
Topics
Community Discussion
No community discussion yet for this question.