Grant LandingLens Access to Stages

Some SQL commands for managing LandingLens on Snowflake require you to grant LandingLens access to Snowflake stages. 

The processes that require LandingLens to have access to stages include:

• Run inference on staged images with SQL commands
• Load images from Snowflake stages

Grant LandingLens Access to a Stage

To grant LandingLens access to a stage:

1. Make a note of the database, schema, and stage that you want to give LandingLens access to.
2. Locate the name of your instance of LandingLens. For instructions on how to do this, go here.
3. Open Snowsight.
4. Create a new worksheet and run the following SQL commands. Replace the YOUR_DB, YOUR_SCHEMA, YOUR_STAGE, and <APP_NAME>placeholders with your information.

   GRANT USAGE ON DATABASE YOUR_DB TO APPLICATION <APP_NAME>;
   GRANT USAGE ON SCHEMA YOUR_DB.YOUR_SCHEMA TO APPLICATION <APP_NAME>;
   GRANT READ ON STAGE YOUR_DB.YOUR_SCHEMA.YOUR_STAGE TO APPLICATION <APP_NAME>;