The App architecture is based on the Native Apps framework that Snowflake provides and is dependent on the SNP Glue™ add-on for SAP that can stream data directly into a Snowflake table.
All SAP systems that are connected to the App share the same database but each uses its 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 Glue™ 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 Glue™.
Users can use the provided view (real-time + merged data) or use only the merged table for data consumption.