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 start using the app, 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 which allows process mining analyses for data in Snowflake Data Cloud. To start using the QPR ProcessAnalyzer app, 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 ==
Line 11: Line 11:


== Manage permissions ==
== Manage permissions ==
Give give access to the QPR ProcessAnalyzer Native App, click the '''Manage access''' button in the app page and add the desired roles that need access to the app.
Give 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 [[Manage_Users_and_Groups|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.
QPR ProcessAnalyzer has a separate [[Manage_Users_and_Groups|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 user management. New users get administrator permissions to QPR ProcessAnalyzer. If there is a need to restrict user permissions, create the users beforehand to QPR ProcessAnalyzer user management and set their permissions as desired.


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:
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
* Database: USAGE
* Schema : USAGE
* Schema : USAGE
Line 21: Line 21:


== Select warehouse ==
== Select warehouse ==
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:
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:


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

Revision as of 08:48, 4 October 2024

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". Install the QPR ProcessAnalyzer Native 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:

  1. Create project in the Workspace.
  2. Go to the project and import model from sample eventlog files.
  3. Double-click the model to start Process Discovery or create dashboard.

Manage permissions

Give 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 a Snowflake user login to QPR ProcessAnalyzer, the user is automatically created to QPR ProcessAnalyzer user management. New users get administrator permissions to QPR ProcessAnalyzer. If there is a need to restrict user permissions, create the users beforehand to QPR ProcessAnalyzer user management and set their permissions as desired.

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

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>;