This section details the process of incorporating application logic into the setup script of an application package. Additionally, it provides guidance on integrating external code files into an application package.
For information specifically related to including a Streamlit app in an application package, refer to the documentation on Adding a Streamlit App to an Application Package.
Considerations for Using Stored Procedures and Functions:
Within the Snowflake Native App Framework, you have the capability to incorporate stored procedures, user-defined functions (UDFs), and external functions into an application package. These components can be authored in any of the languages supported by Snowflake.
Adding Application Code Securely:
All stored procedures and user-defined functions (UDFs) within a Snowflake Native App operate under the context of the application, possessing access to all objects within the installed Snowflake Native App. This scenario poses a risk of SQL injection attacks.
When creating procedures and functions intended for use within a Snowflake Native App, it is advised to follow best practices by utilizing bound parameters for all SQL commands that involve user input. This precaution applies to input received through procedure arguments.
For further details, refer to the documentation on Creating a Stored Procedure.