App Quick Start

After the installation of the native application, there are a few necessary steps to set it up. The whole setup is done using the application´s Streamlit UI. It can be found in Data Products → Apps.

The first step is to grant appropriate account privileges to the application. This can be done by accessing the Security settings in the UI, located at the top-right of the screen.

Necessary account privileges are:

EXECUTE TASK
CREATE DATABASE
EXECUTE MANAGED TASK

Next, a USAGE privilege on a warehouse is needed for the housekeeping task. This is done in the Security → Privileges to objects.

Grant application roles to the technical role. This role must be the same one as the one specified in the storage connection in SNP Glue. To grant them, go to the Managed Access in the top right. Select the role from the dropdown menu and then assign SNP_GLUE_CORE and SNP_GLUE_SAP application roles. More about application roles can be found here https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5726084834.

The next step is to create a database and a schema. They both need to be created by the native application. To do so, go to the left side of the Streamlit UI and expand Select database and Select Schema. Then, enter the name of the database and click Create. After that, do the same with the schema. More information can be found in https://datavard.atlassian.net/wiki/spaces/GLUE/pages/4275634232/App+User+Interface#Source-management .

Next, in the Settings tab, define the settings for the selected schema. The recommended settings are set as the default settings. More information regarding each setting can be found here https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/5726085003.

The last step is to connect the SNP Glue to the native application. Go to the storage connection settings in SNP Glue. First, enter the newly created database schema.

Then, check the Use Snowflake App for data merge and enter the name of the application.