(Glue-2305) App Architecture

Owned by Robert Adamec
Last updated: Jul 06, 2023 by Marian Vidra
1 min read

The App architecture is based on the Native Apps framework that Snowflake provides and is dependent on the SNP GlueTM add-on for SAP that is able to stream data directly into a Snowflake table.

All SAP systems that are connected to the App share the same database but each is using its own schema when it is registered using UI or procedure.

Each SAP system has settings that define the deployment of the merge procedures - naming conventions and runtime of the merge tasks - which warehouse will be used and the frequency of the tasks.

The core of the functionality is the merge deployment procedure. It creates all necessary objects - stream, task, merge table, and view. Information about this action and the objects created is stored in the metadata table of the App.

When SNP GlueTM creates a table for the data ingestion it is called through a stored procedure provided by the App. It grants all necessary permissions to the application role. The same applies to the changes or deletion of the table that is managed by SNP GlueTM.

Users can use provided view (real-time + merged data) or use only the merged table for data consumption.