What privileges are required to create a stage that uses a storage integration?

• A. CREATE STAGE on the schema and USAGE on storage integration
• B. USAGE on the stage only
• C. USAGE on the schema only
• D. CREATE STAGE on the storage integration

Answer: (A)

Two kinds of privileges matter here: the ability to create the stage within the schema and the ability to reference the storage integration. To create the stage, Snowflake needs CREATE STAGE on the target schema. Once the stage exists, it must be tied to a storage integration, which requires USAGE on the storage integration so the stage can use that integration. Without CREATE on the schema, you can’t create the stage; without USAGE on the storage integration, the stage can’t be configured to use it. The other options don’t provide both pieces of access, so the correct combination is CREATE STAGE on the schema and USAGE on the storage integration.