QPR ProcessAnalyzer Native App in Snowflake: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:


QPR ProcessAnalyzer can run as Snowflake Native App. To get started, go to the [https://app.snowflake.com/marketplace Snowflake Marketplace] and search "QPR ProcessAnalyzer". Install the QPR ProcessAnalyzer Native App and click the '''Launch App''' button
QPR ProcessAnalyzer can run as Snowflake Native App. To get started, go to the [https://app.snowflake.com/marketplace Snowflake Marketplace] and search "QPR ProcessAnalyzer". Install the QPR ProcessAnalyzer Native App and click the '''Launch App''' button.


== Get started ==
== Get started ==

Revision as of 09:32, 3 October 2024

QPR ProcessAnalyzer can run as Snowflake Native App. To get started, go to the Snowflake Marketplace and search "QPR ProcessAnalyzer". Install the QPR ProcessAnalyzer Native App and click the Launch App button.

Get started

Load data

QPR ProcessAnalyzer Native App is initially empty. You can use existing eventlog data in Snowflake or import example eventlogs as follows:

  1. Create project.
  2. Import model. (Sample eventlogs)
  3. Create dashboard.

Manage permissions

QPR ProcessAnalyzer has a separate User Management which is integrated into Snowflake user management. When a Snowflake user login to QPR ProcessAnalyzer Native App, the user is automatically created to QPR ProcessAnalyzer. New users get by default administrator permissions to QPR ProcessAnalyzer. If you need to restrict user permissions, create the users beforehand to QPR ProcessAnalyzer and set their permissions as desired.

To use the QPR ProcessAnalyzer Native App, Snowflake users need to be given the USAGE privilege to the QPR ProcessAnalyzer service. More information: https://docs.snowflake.com/en/developer-guide/snowpark-container-services/working-with-services#granting-the-usage-privilege-on-all-endpoints-using-the-default-service-role

QPR ProcessAnalyzer Native App need to have access to data in Snowflake and it's limited by the permissions given to the owner role of the QPR ProcessAnalyzer service. Give permissions to that role for databases containing eventlog data that will be analyzed in the QPR ProcessAnalyzer Native App. At least following privileges are needed:

  • Database: USAGE
  • Schema : USAGE
  • Table/view: SELECT

Use virtual warehouses

When QPR ProcessAnalyzer Native App installed, XS-size virtual warehouse is created and it's used by default. Different warehouse can be used by changing it with the following command:

ALTER SERVICE <service_name> SET QUERY_WAREHOUSE = <warehouse_name>;