QPR ProcessAnalyzer Native App in Snowflake: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 4: Line 4:
== Load data ==
== Load data ==
# [[QPR_ProcessAnalyzer_Project_Workspace#Creating_Project|Create project]].
# [[QPR_ProcessAnalyzer_Project_Workspace#Creating_Project|Create project]].
# [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Model|Import model]].
# [[QPR_ProcessAnalyzer_Project_Workspace#Importing_Model|Import model]]. ([[Sample_Eventlog_Files|Sample eventlogs]])
# [[QPR_ProcessAnalyzer_Project_Workspace#Creating_Dashboard|Create dashboard]].
# [[QPR_ProcessAnalyzer_Project_Workspace#Creating_Dashboard|Create dashboard]].



Revision as of 07:59, 3 October 2024

Get started

Load data

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

Manage permissions

QPR ProcessAnalyzer has an own User Management which is integrated into Snowflake user management. When a Snowflake user login to QPR ProcessAnalyzer, 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 the QPR ProcessAnalyzer and set the permissions as desired.

To use the QPR ProcessAnalyzer Native App, Snowflake users need to be given 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 that is limited by permissions given to the owner role of the service. Assign permissions to that role for all databases containing eventlog data.

Use virtual warehouses

When QPR ProcessAnalyzer Native App installed, an 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>;