Grant LandingLens Access to Stages
  • 11 Dec 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Grant LandingLens Access to Stages

  • Dark
    Light
  • PDF

Article summary

This article applies to these versions of LandingLens:

LandingLensLandingLens on Snowflake

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:

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 these placeholders with your information: YOUR_DB, YOUR_SCHEMA, YOUR_STAGE, and <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 ON STAGE YOUR_DB.YOUR_SCHEMA.YOUR_STAGE TO APPLICATION <APP_NAME>;

Was this article helpful?