You are developing a Snowpark Python application that needs to read data from an external stage. You have already created the stage named which points to an AWS S3 bucket containing Parquet files…

Question

Options

• AGrant the 'USAGE privilege on the stage to the role that executes the Snowpark application.
• BGrant the 'READ privilege on the stage to the role that executes the Snowpark application. (Note:
• CEnsure that the storage integration associated with has the appropriate AWS IAM role configured
• DGrant the 'SELECT privilege on the underlying S3 bucket to the role that executes the Snowpark
• EGrant the 'EXECUTE TASK' privilege on the stage to the role that executes the Snowpark

• A
  78% (40)
• B
  6% (3)
• D
  4% (2)
• E
  12% (6)

Explanation

To access an external stage from a Snowpark application, two things must be in place. Option A is required: the executing role needs the USAGE privilege on the stage object itself to reference and read from it. Option C is required: the external stage uses a storage integration to authenticate with AWS S3, and that storage integration must have the correct AWS IAM role and trust policy configured so Snowflake can actually access the S3 bucket. Without a properly configured IAM role, Snowflake cannot authenticate to S3 regardless of Snowflake-level privileges. Option B is incorrect because Snowflake does not have a 'READ' privilege for stages-USAGE is the relevant privilege. Option D is incorrect because AWS IAM permissions on the S3 bucket are managed through the storage integration, not granted directly to a Snowflake role. Option E (EXECUTE TASK) is entirely unrelated to stage access.

No community discussion yet for this question.