QPR ProcessAnalyzer Native App in Snowflake
QPR ProcessAnalyzer can run as Snowflake Native App which allows process mining analyses for data in Snowflake Data Cloud. To start using the QPR ProcessAnalyzer app, go to the Snowflake Marketplace and search "QPR ProcessAnalyzer". Click the Get button in the marketplace, grant required account level privileges to the app, click the Activate button to install the app, and click the Launch App button.
Get started
QPR ProcessAnalyzer Native App requires eventlog data extracted from source systems. Data in Snowflake need to be converted into the suitable eventlog format.
To get started, you can also import example eventlogs as follows:
- Create project in the Workspace.
- Go to the project and import model from sample eventlog files.
- Double-click the model to start Process Discovery or create dashboard.
Manage access
User access to application
Give access to the QPR ProcessAnalyzer Native App by clicking the Manage access button in the app page and add the desired roles to the app users.
QPR ProcessAnalyzer has a separate User Management which is integrated into Snowflake user management. When QPR ProcessAnalyzer is installed, the Snowflake user who installed the application, is automatically created to QPR ProcessAnalyzer user management as system administrator. This user needs to open QPR ProcessAnalyzer, go to the User Management, and create other users.
Application access to data
QPR ProcessAnalyzer Native App needs an access to data in Snowflake that is limited by permissions given to the owner role of the QPR ProcessAnalyzer service. Give permissions to that role for databases containing source eventlog data that will be analyzed in the QPR ProcessAnalyzer. At least following privileges are needed:
- Database: USAGE
- Schema : USAGE
- Table/view: SELECT
Privileges to install application
QPR ProcessAnalyzer requires following account level privileges:
- BIND SERVER ENDPOINT
- CREATE COMPUTE POOL
- CREATE WAREHOUSE
Select warehouse
QPR ProcessAnalyzer Native App includes an XS-size virtual warehouse which is used by default. Another warehouse can be used by changing it using the following command:
ALTER SERVICE <service_name> SET QUERY_WAREHOUSE = <warehouse_name>;
Notes
QPR ProcessAnalyzer (running in the Snowpark Container Services) automatically starts up when a user logs in. QPR ProcessAnalyzer container doesn't stop automatically, but it can be stopped manually if desired (ALTER SERVICE <name> SUSPEND). When the QPR ProcessAnalyzer container is not running, the compute pool will stop automatically after an hour. Also the compute pool will startup automatically when QPR ProcessAnalyzer container needs to run.
Snowflake has a one minute timeout for http requests, so long running operations may reach this timeout and fail. For example, importing large model from pacm or json file may encounter this situation. However, CSV data import doesn't have this issue.
Uninstall
QPR ProcessAnalyzer Native App can be uninstalled like any other app. Note that if QPR ProcessAnalyzer is uninstalled, the configuration data, such as projects, models, dashboards and scripts, are lost. However, the eventlog data residing in Snowflake tables are preserved.