(Glue 2402) App Installation Guide

Marketplace listing

After clicking Get, additional options are provided to select the Warehouse to be used and the name of the App in the current account.

Form to install the Native App

Installing the App will create a special database where SQL procedures and Streamlit are installed.

Required authorizations

To make the App able to run the processing, it needs to be granted authorization to use a Warehouse to run merge tasks.

-- Grant permission for warehouse usage
GRANT USAGE ON WAREHOUSE <Warehouse> TO APPLICATION <Application name>;

The application can use multiple warehouses based on the data processing requirements.

Additional authorizations are required for users of the App and for the SNP Glue™ add-on for SAP that will be sending the data.

First you need to give usage to the warehouse that will be used to run housekeeping task.

This warehouse will not be used to run merge tasks.

Next popup asks you to grant:

Create database: Due to privileges constrains application needs to own databases it uses. Therefore, it needs to create it itself, as there is not an option to transfer ownership to the application.
Execute task: To create and execute merge tasks.

After both “EXECUTE TASK” and housekeeping warehouse are granted. The housekeeping task is created automatically.