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

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.