Skip to main content
To parse or extract data from files in Snowflake stages, grant access to those stages. To grant access to a stage:
  1. Make a note of the database, schema, and stage that you want to grant access to.
  2. Open Snowsight.
  3. Create a new worksheet and run the following SQL commands. Replace these placeholders with your information: YOUR_DB, YOUR_SCHEMA, YOUR_STAGE, and APP_NAME. (To locate your app name, go to App Name). 
    GRANT USAGE ON DATABASE YOUR_DB TO APPLICATION "APP_NAME";
GRANT USAGE ON SCHEMA YOUR_DB.YOUR_SCHEMA TO APPLICATION "APP_NAME";
GRANT READ, WRITE ON STAGE YOUR_DB.YOUR_SCHEMA.YOUR_STAGE TO APPLICATION "APP_NAME";