COF-C02 · Question #243
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
The correct answer is A. READ. To access unstructured data files stored in a Snowflake external stage via a file URL using the GET REST API, the calling role must have at minimum the READ privilege on that stage. READ allows the role to list and retrieve files from the stage without the ability to write or…
Question
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
Options
- AREAD
- BOWNERSHIP
- CUSAGK
- DWRTTF
How the community answered
(26 responses)- A88% (23)
- B8% (2)
- D4% (1)
Explanation
To access unstructured data files stored in a Snowflake external stage via a file URL using the GET REST API, the calling role must have at minimum the READ privilege on that stage. READ allows the role to list and retrieve files from the stage without the ability to write or manage it. OWNERSHIP (B) is far more than the minimum required and grants full control of the object. Options C (USAGK) and D (WRTTF) are misspellings of USAGE and WRITE respectively - neither is the correct minimum privilege for this use case. READ is the least-permissive privilege that still grants access to download file data from a stage.
Topics
Community Discussion
No community discussion yet for this question.