/
App Installation Guide

App Installation Guide

Before starting with the installation of the App, there are a few prerequisites:

  • License, install, and configure Kyano Glue. To do so, please get in touch with the Kyano Glue sales team at glue@snpgroup.com.

  • Configure a connection from SAP to Snowflake. A guide to doing so can be found here(SM-2502) Snowflake Storage Setup .

An application can be installed via the Snowflake Marketplace. Follow Snowflake’s guide to install the Glue Connector for SAP listinghttps://other-docs.snowflake.com/en/native-apps/consumer-installing#install-an-app-from-a-snowflake-marketplace-listing.

Before opening the application

First authorization to use a warehouse needs to be granted to the App. These warehouses will be utilized for data de-duplication. An XSMALL warehouse should be adequate for development environments, while a SMALL or larger warehouse is recommended for quality and production environments.

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

To do so, execute the following GRANT command.

Without granting usage on the warehouse, merge tasks will be created as serverless tasks using XSMALL size by default.

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

After opening the application.

This warehouse will not be used to run de-duplication tasks.

Upon opening the application, two pop-ups should appear.

The first pop-up assigns usage to the warehouse that will handle application tasks, with housekeeping being the only current task.

The second pop-up grants the following permissions:

  • Create database: Due to privilege constraints, the application must own the databases it uses. Since ownership cannot be transferred, the application must create them itself.

  • Execute task: Allows the creation and execution of merge tasks.

  • Execute managed tasks: Enables the creation and execution of merge tasks when no warehouse is assigned to the application and supports running "Source" tasks. To learn more about them, visitApp Architecture | Controller Tasks for Automated Operations.

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

In case the housekeeping task is not created automatically, it can be found in the application database and schema APP, e.g., SNP_GLUE_CONNECTOR_FOR_SAP.APP.HOUSEKEEPING, execute the following stored procedure to create it: <app_name>.core.create_housekeeping_task().

To set up the application, please refer to the quick start guideApp Quick Start.