If you are using an existing stage to access external tables, which permission is required on the Stage?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

If you are using an existing stage to access external tables, which permission is required on the Stage?

Explanation:
Accessing data through an existing stage requires the USAGE privilege on that stage. In Snowflake, a stage is the reference to a data location, and you must be allowed to use that stage in queries (such as when defining or querying external tables) before Snowflake will read from it. MODIFY, CREATE STAGE, or similar privileges aren’t needed merely to consume data from an already-defined stage—their roles are to change the stage, create new ones, or grant broader control. The USAGE grant is the minimal and correct permission to reference and use the stage for external-table operations.

Accessing data through an existing stage requires the USAGE privilege on that stage. In Snowflake, a stage is the reference to a data location, and you must be allowed to use that stage in queries (such as when defining or querying external tables) before Snowflake will read from it. MODIFY, CREATE STAGE, or similar privileges aren’t needed merely to consume data from an already-defined stage—their roles are to change the stage, create new ones, or grant broader control. The USAGE grant is the minimal and correct permission to reference and use the stage for external-table operations.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy