Design Guidelines and Constraints for Functions and Procedures¶
This topic describes constraints and guidelines to keep in mind when writing UDFs and stored procedures.
- Keeping Handler Code In-line or on a Stage
Choose whether to have your handler code in-line or packaged in a separate file.
- Designing Handlers that Stay Within Snowflake-Imposed Constraints
Ensure stability within the Snowflake environment by developing within constraints described in this topic.
- Data Type Mappings Between SQL and Handler Languages
Choose the best data types for argument and return values in handler code.
- Naming Conventions for Procedures and UDFs
Name form and overloading rules for procedures and UDFs.
- Making Dependencies Available to Your Code
Make your handler or its dependencies available for use at runtime on Snowflake.
- Security Practices for UDFs and Procedures
Help your handler code execute securely using these best practices.
- Protecting Sensitive Information with Secure UDFs and Stored Procedures
Ensure that sensitive information is concealed from users who should not have access to it.
- Pushdown Optimization and Data Visibility
Learn about the pushdown optimization that makes queries more efficient, but which can also expose data that you might not want to be visible.