Installation and Update

Prerequisites

The Snowflake native app can be installed via the Snowflake Marketplace. Simply search for mpmX - Process Mining for Snowflake and follow the setup instructions.

Snowflake Marketplace

Alternatively, contact your MEHRWERK sales representative and provide them with the following information:

• Your Snowflake organization and account name (see Finding the organization and account name for an account)
• (optional) Your Snowflake region ID

Warehouses

Installing and using the app involves setting up various warehouses.

Purpose	Warehouse Size
Installation	An XSMALL warehouse is sufficient for this task. In most cases, a default warehouse has been set up for your user. This will then be used here.
Using the app	The Native App uses Streamlit to display the configuration UI, which in turn requires a warehouse to operate. The warehouse size XSMALL is sufficient here.
Process Mining/Background Task	This warehouse is selected during the initial setup, but can be changed later. The appropriate warehouse size depends largely on your event logs (data sets) and your time requirements.

Roles and permissions

OWNER role

For the installation of the mpmX Snowflake App, it is recommended to create an account role MPMX_ADMIN, which will be the OWNER of the application after installation. In order for the app to be installed, the MPMX_ADMIN role must first be given the CREATE APPLICATION and IMPORT SHARE permissions.

Snowflake Web UI (Snowsight)

1. Create MPMX_ADMIN account role

   

   Create Role

2. Grant global privileges to MPMX_ADMIN

   

   Grant Global Privileges

SQL

CREATE ROLE IF NOT EXISTS MPMX_ADMIN COMMENT = 'mpmX Admin';
GRANT CREATE APPLICATION ON ACCOUNT TO ROLE MPMX_ADMIN;
GRANT IMPORT SHARE ON ACCOUNT TO ROLE MPMX_ADMIN;

ACCOUNTADMIN role

Since the Native App uses Tasks to regularly run its application logic, you will be asked to select a warehouse to be used by the tasks and you also have to grant the Native App the EXECUTE TASK privilege to allow for the scheduling of the tasks. This privilege can only be granted by an ACCOUNTADMIN.

Snowflake Documentation » Access control privileges » Global privileges (account-level privileges)

ACCOUNTADMIN Privileges

Installation

You can find the mpmX Snowflake app as a privately shared listing in your Snowflake account.

Snowflake Web UI (Snowsight)

1. Make sure that your current role is correct, as this role will be the OWNER of the application after installation.

   You can see your current role in the bottom left corner

   

   Current User Role

2. Click on the "Get" button.

   

   Privately Shared Listings » mpmX

3. Choose a warehouse to be used during the installation.

   

   Choose a Warehouse

4. If you want to change the application name, expand the Options block and enter the appropriate name.

   Continue with the "Get" button.

5. The installation will take a moment and then you will see a confirmation screen telling you that the installation was successful.

   Click on "Configure" to open the application for the first time.

   

   Successfully Installed Pop-Up

6. The first time you access the application, you will be asked to select a warehouse from which to run the process mining.

   

   Warehouse USAGE Privilege

7. You will also need to grant the EXECUTE TASK privilege to allow for the scheduling of the process mining. This requires an ACCOUNTADMIN user.

   

   EXECUTE TASK Privilege

SQL

1. Install the App from the shared private listing.

   Make sure that the MPMX_ADMIN user is used for the installation.

   USE ROLE MPMX_ADMIN;
   CREATE APPLICATION MPMX_APP FROM LISTING GZSYZPF2MY BACKGROUND_INSTALL = TRUE;

   In the example above, MPMX_APP is the name under which the application was installed.

2. Once installed, the application must be authorized to execute tasks. This privilege can only be granted by ACCOUNTADMIN.

   USE ROLE ACCOUNTADMIN;
   GRANT EXECUTE TASK ON ACCOUNT TO APPLICATION MPMX_APP;

3. And also be authorized to use the mining task warehouse

   GRANT USAGE ON WAREHOUSE <mining_task_warehouse> TO APPLICATION MPMX_APP;

This completes the setup and you are ready to take the first steps, e.g. create a process scenario.

Update

When an updated version is provided for your account, it will be installed automatically.

Current version

Snowflake Web UI (Snowsight)

To view the current version of your app in Snowsight navigate to Data Products » Apps. Note, that the version is only shown in the List view.

Data Products » Apps

SQL

To check the current version of your app by running the following SQL statement.

BEGIN
    SHOW APPLICATIONS;
    LET res RESULTSET := (
        SELECT "name" AS application
             , "version" || '.' || "patch" AS version
        FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()))
        WHERE "source" = 'GZSYZPF2MY'
    );

    RETURN TABLE(res);
END;