Skip to content

Installation

Prerequisites

Before installing PerfScope, ensure that you have:

  • A Snowflake account
  • Sufficient privileges to install a Snowflake Native App
  • A Snowflake virtual warehouse that PerfScope can use for analytical queries
  • Permission to grant the application access to the Snowflake system database where required

An XS or S warehouse is sufficient for many accounts. Larger or high-volume Snowflake environments may benefit from a larger warehouse.

Install from Snowflake Marketplace

  1. Sign in to Snowsight.
  2. Open Marketplace.
  3. Search for PERFSCOPE.
  4. Open the PerfScope listing.
  5. Select Get.
  6. Follow the Snowflake installation prompts.
  7. Complete any requested privilege grants.

Post-installation configuration

Depending on the privileges requested by the application, your administrator may need to grant access similar to the following.

-- Allow PerfScope to use a warehouse.
GRANT USAGE
ON WAREHOUSE <your_warehouse>
TO APPLICATION PERFSCOPE;

-- Allow PerfScope to read the Snowflake system database
-- where applicable to your Native App configuration.
GRANT IMPORTED PRIVILEGES
ON DATABASE SNOWFLAKE
TO APPLICATION PERFSCOPE;

Warning

Replace <your_warehouse> with the warehouse you want PerfScope to use.

Note

The exact privileges available to a Snowflake Native App depend on the application's manifest, requested references, Snowflake Native App security model, and the privileges approved during installation. Follow the privileges shown by Snowflake during the installation flow if they differ from the examples above.

Verify installation

After configuration:

  1. Open Apps in Snowsight.
  2. Select PerfScope.
  3. Launch the application.
  4. Confirm that the main dashboard loads.
  5. Select a query-analysis time range.

Query metadata should begin appearing after the app can access the required Snowflake metadata.

If the dashboard remains empty, see Troubleshooting.