> ## Documentation Index
> Fetch the complete documentation index at: https://landinglens.docs.landing.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Grant LandingLens Access to Stages

export const vp = 'Visual Prompting';

export const smartLabel = 'Smart Labeling';

export const productLL = 'LandingLens';

export const mi = 'Mobile Inference';

export const llsf = 'LandingLens on Snowflake';

export const companyName = 'LandingAI';

*This article applies to these versions of LandingLens:*

<table>
  <thead>
    <tr>
      <th>LandingLens</th>
      <th>LandingLens on Snowflake</th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td><span class="cross-icon">✖</span></td>
      <td><span class="check-icon">✓</span></td>
    </tr>
  </tbody>
</table>

Some SQL commands for managing {llsf} 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](./run-inference-with-sql-commands)
* [Load images from Snowflake stages](./load-images-from-snowflake)

## 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](./app-name).
3. Open [Snowsight](https://app.snowflake.com).
4. 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>`.

```bash theme={null}
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>;
```