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.
Without granting usage on warehouse merge tasks will be created as serverless task using XSMALL size by default.
-- 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.
After opening the application.
First you need to give usage to the warehouse that will be used to run application tasks; Currently only such task is housekeeping.
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 application warehouse are granted. The housekeeping task is created automatically.