| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/sql/create-function |
| Français | https://docs.snowflake.com/fr/sql-reference/sql/create-function |
| Deutsch | https://docs.snowflake.com/de/sql-reference/sql/create-function |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/sql/create-function |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/sql/create-function |
| Português | https://docs.snowflake.com/pt/sql-reference/sql/create-function |
| Get started | https://docs.snowflake.com/en/user-guide-getting-started |
| Guides | https://docs.snowflake.com/en/guides |
| Developer | https://docs.snowflake.com/en/developer |
| Reference | https://docs.snowflake.com/en/reference |
| Release notes | https://docs.snowflake.com/en/release-notes/overview |
| Tutorials | https://docs.snowflake.com/en/tutorials |
| Status | https://status.snowflake.com |
| Overview | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Query syntax | https://docs.snowflake.com/en/sql-reference/constructs |
| Query operators | https://docs.snowflake.com/en/sql-reference/operators |
| General DDL | https://docs.snowflake.com/en/sql-reference/sql-ddl-summary |
| General DML | https://docs.snowflake.com/en/sql-reference/sql-dml |
| All commands (alphabetical) | https://docs.snowflake.com/en/sql-reference/sql-all |
| Accounts | https://docs.snowflake.com/en/sql-reference/commands-account |
| Users, roles, & privileges | https://docs.snowflake.com/en/sql-reference/commands-user-role |
| Integrations | https://docs.snowflake.com/en/sql-reference/commands-integration |
| Business continuity & disaster recovery | https://docs.snowflake.com/en/sql-reference/commands-replication |
| Sessions | https://docs.snowflake.com/en/sql-reference/commands-session |
| Transactions | https://docs.snowflake.com/en/sql-reference/commands-transaction |
| Virtual warehouses & resource monitors | https://docs.snowflake.com/en/sql-reference/commands-warehouse |
| Databases, schemas, & shares | https://docs.snowflake.com/en/sql-reference/commands-database |
| Tables, views, sequences, and types | https://docs.snowflake.com/en/sql-reference/commands-table |
| Functions, procedures, & scripting | https://docs.snowflake.com/en/sql-reference/commands-function |
| ALTER FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/alter-function |
| CREATE FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/create-function |
| DROP FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/drop-function |
| DESCRIBE FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/desc-function |
| SHOW USER FUNCTIONS | https://docs.snowflake.com/en/sql-reference/sql/show-user-functions |
| CREATE DATA METRIC FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/create-data-metric-function |
| ALTER FUNCTION (DMF) | https://docs.snowflake.com/en/sql-reference/sql/alter-function-dmf |
| DESCRIBE FUNCTION (DMF) | https://docs.snowflake.com/en/sql-reference/sql/desc-function-dmf |
| DROP FUNCTION (DMF) | https://docs.snowflake.com/en/sql-reference/sql/drop-function-dmf |
| SHOW DATA METRIC FUNCTIONS | https://docs.snowflake.com/en/sql-reference/sql/show-data-metric-functions |
| CREATE FUNCTION (Service) | https://docs.snowflake.com/en/sql-reference/sql/create-function-spcs |
| ALTER FUNCTION (Service) | https://docs.snowflake.com/en/sql-reference/sql/alter-function-spcs |
| DESCRIBE FUNCTION (Service) | https://docs.snowflake.com/en/sql-reference/sql/desc-function-spcs |
| DROP FUNCTION (Service) | https://docs.snowflake.com/en/sql-reference/sql/drop-function-spcs |
| CREATE EXTERNAL FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/create-external-function |
| ALTER FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/alter-function |
| SHOW EXTERNAL FUNCTIONS | https://docs.snowflake.com/en/sql-reference/sql/show-external-functions |
| DROP FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/drop-function |
| DESCRIBE FUNCTION | https://docs.snowflake.com/en/sql-reference/sql/desc-function |
| CALL | https://docs.snowflake.com/en/sql-reference/sql/call |
| CALL WITH | https://docs.snowflake.com/en/sql-reference/sql/call-with |
| CREATE PROCEDURE | https://docs.snowflake.com/en/sql-reference/sql/create-procedure |
| ALTER PROCEDURE | https://docs.snowflake.com/en/sql-reference/sql/alter-procedure |
| DROP PROCEDURE | https://docs.snowflake.com/en/sql-reference/sql/drop-procedure |
| SHOW PROCEDURES | https://docs.snowflake.com/en/sql-reference/sql/show-procedures |
| DESCRIBE PROCEDURE | https://docs.snowflake.com/en/sql-reference/sql/desc-procedure |
| SHOW USER PROCEDURES | https://docs.snowflake.com/en/sql-reference/sql/show-user-procedures |
| EXECUTE IMMEDIATE | https://docs.snowflake.com/en/sql-reference/sql/execute-immediate |
| EXECUTE IMMEDIATE FROM | https://docs.snowflake.com/en/sql-reference/sql/execute-immediate-from |
| Streams & tasks | https://docs.snowflake.com/en/sql-reference/commands-stream |
| DCM Projects | https://docs.snowflake.com/en/sql-reference/commands-dcm-projects |
| dbt Projects on Snowflake | https://docs.snowflake.com/en/sql-reference/commands-dbt-projects-on-snowflake |
| Classes & instances | https://docs.snowflake.com/en/sql-reference/commands-class |
| Machine learning | https://docs.snowflake.com/en/sql-reference/commands-ml |
| Cortex | https://docs.snowflake.com/en/sql-reference/commands-cortex |
| Listings | https://docs.snowflake.com/en/sql-reference/commands-listings |
| Openflow data plane integration | https://docs.snowflake.com/en/sql-reference/commands-ofdata-plane |
| Organization profiles | https://docs.snowflake.com/en/sql-reference/commands-organization-profiles |
| Security | https://docs.snowflake.com/en/sql-reference/commands-security |
| Data Governance | https://docs.snowflake.com/en/sql-reference/commands-data-governance |
| Privacy | https://docs.snowflake.com/en/sql-reference/commands-privacy |
| Data loading & unloading | https://docs.snowflake.com/en/sql-reference/commands-data-loading |
| File staging | https://docs.snowflake.com/en/sql-reference/commands-file |
| Storage lifecycle policies | https://docs.snowflake.com/en/sql-reference/commands-storage-lifecycle-policies |
| Git | https://docs.snowflake.com/en/sql-reference/commands-git |
| Alerts | https://docs.snowflake.com/en/sql-reference/commands-alert |
| Native Apps Framework | https://docs.snowflake.com/en/sql-reference/commands-native-apps |
| Snowflake App Runtime | https://docs.snowflake.com/en/sql-reference/commands-snowflake-apps |
| Streamlit | https://docs.snowflake.com/en/sql-reference/commands-streamlit |
| Notebook | https://docs.snowflake.com/en/sql-reference/commands-notebook |
| Snowpark Container Services | https://docs.snowflake.com/en/sql-reference/commands-snowpark-container-services |
| Snowflake Postgres | https://docs.snowflake.com/en/user-guide/snowflake-postgres/about |
| Function and stored procedure reference | https://docs.snowflake.com/en/sql-reference-functions |
| Class reference | https://docs.snowflake.com/en/sql-reference-classes |
| Scripting reference | https://docs.snowflake.com/en/sql-reference-snowflake-scripting |
| General reference | https://docs.snowflake.com/en/sql-reference |
| API reference | https://docs.snowflake.com/en/api-reference |
| Reference | https://docs.snowflake.com/en/reference |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Functions, procedures, & scripting | https://docs.snowflake.com/en/sql-reference/commands-function |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#create-function |
| UDF (user-defined function) | https://docs.snowflake.com/developer-guide/udf/udf-overview |
| Keeping handler code in-line or on a stage | https://docs.snowflake.com/developer-guide/inline-or-staged |
| Java | https://docs.snowflake.com/developer-guide/udf/java/udf-java-introduction |
| JavaScript | https://docs.snowflake.com/developer-guide/udf/javascript/udf-javascript-introduction |
| Python | https://docs.snowflake.com/developer-guide/udf/python/udf-python-introduction |
| Scala | https://docs.snowflake.com/developer-guide/udf/scala/udf-scala-introduction |
| SQL | https://docs.snowflake.com/developer-guide/udf/sql/udf-sql-introduction |
| Variant syntax | https://docs.snowflake.com/en/sql-reference/sql/create-function#label-create-or-alter-function-syntax |
| ALTER FUNCTION | https://docs.snowflake.com/sql-reference/sql/alter-function |
| DROP FUNCTION | https://docs.snowflake.com/sql-reference/sql/drop-function |
| SHOW USER FUNCTIONS | https://docs.snowflake.com/sql-reference/sql/show-user-functions |
| DESCRIBE FUNCTION | https://docs.snowflake.com/sql-reference/sql/desc-function |
| CREATE OR ALTER | https://docs.snowflake.com/sql-reference/sql/create-or-alter |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#syntax |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#java-handler |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#javascript-handler |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#python-handler |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#scala-handler |
| Preview Feature | https://docs.snowflake.com/release-notes/preview-features |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#sql-handler |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#variant-syntax |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#create-or-alter-function |
| Preview Feature | https://docs.snowflake.com/release-notes/preview-features |
| ALTER FUNCTION | https://docs.snowflake.com/sql-reference/sql/alter-function |
| CREATE OR ALTER FUNCTION usage notes | https://docs.snowflake.com/en/sql-reference/sql/create-function#label-create-or-alter-function-usage-notes |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#required-parameters |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#all-languages |
| identified and resolved by the combination of the name and argument types | https://docs.snowflake.com/developer-guide/udf-stored-procedure-naming-conventions#label-procedure-function-name-overloading |
| Identifier requirements | https://docs.snowflake.com/sql-reference/identifiers-syntax |
| Java handlers | https://docs.snowflake.com/developer-guide/udf/java/udf-java-introduction |
| SQL-Java Data Type Mappings | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-java-data-type-mappings |
| JavaScript handlers | https://docs.snowflake.com/developer-guide/udf/javascript/udf-javascript-introduction |
| SQL and JavaScript data type mapping | https://docs.snowflake.com/developer-guide/stored-procedure/stored-procedures-javascript#label-stored-procedure-data-type-mapping |
| Python handlers | https://docs.snowflake.com/developer-guide/udf/python/udf-python-introduction |
| SQL-Python Data Type Mappings | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-python-data-type-mappings |
| Scala handlers | https://docs.snowflake.com/developer-guide/udf/scala/udf-scala-introduction |
| SQL-Scala Data Type Mappings | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-types-to-scala-types |
| Specify optional arguments | https://docs.snowflake.com/developer-guide/udf-stored-procedure-arguments#label-procedure-function-arguments-optional |
| SQL-Java Type Mappings table | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-java-data-type-mappings |
| SQL-Python Type Mappings table | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-python-data-type-mappings |
| SQL-Scala Type Mappings table | https://docs.snowflake.com/developer-guide/udf-stored-procedure-data-type-mapping#label-sql-types-to-scala-types |
| Introduction to Java UDFs | https://docs.snowflake.com/developer-guide/udf/java/udf-java-introduction |
| Introduction to JavaScript UDFs | https://docs.snowflake.com/developer-guide/udf/javascript/udf-javascript-introduction |
| Introduction to Python UDFs | https://docs.snowflake.com/developer-guide/udf/python/udf-python-introduction |
| Introduction to Scala UDFs | https://docs.snowflake.com/developer-guide/udf/scala/udf-scala-introduction |
| Introduction to SQL UDFs | https://docs.snowflake.com/developer-guide/udf/sql/udf-sql-introduction |
| General usage notes | https://docs.snowflake.com/en/sql-reference/sql/create-function#label-create-function-usage-notes |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#java |
| Reading a file specified statically in IMPORTS | https://docs.snowflake.com/developer-guide/udf/java/udf-java-cookbook#label-reading-file-from-java-udf-imports |
| Snowpark package | https://docs.snowflake.com/en/developer-guide/snowpark/reference/java/index.html |
| function definition | https://docs.snowflake.com/sql-reference/sql/create-function#label-create-udf-function-definition |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#javascript |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#python |
| Reading files and assets | https://docs.snowflake.com/developer-guide/udf/python/udf-python-examples#label-udf-python-read-files |
| numpy | https://numpy.org/doc/stable/ |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#scala |
| Writing code to support different Scala versions | https://docs.snowflake.com/developer-guide/scala-version-differences |
| Reading a file specified statically in IMPORTS | https://docs.snowflake.com/developer-guide/udf/java/udf-java-cookbook#label-reading-file-from-java-udf-imports |
| Snowpark package | https://docs.snowflake.com/en/developer-guide/snowpark/reference/java/index.html |
| function definition | https://docs.snowflake.com/sql-reference/sql/create-function#label-create-udf-function-definition |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#optional-parameters |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#all-languages |
| Protecting Sensitive Information with Secure UDFs and Stored Procedures | https://docs.snowflake.com/developer-guide/secure-udf-procedure |
| session | https://docs.snowflake.com/user-guide/session-policies |
| user-defined functions | https://docs.snowflake.com/developer-guide/udf/udf-overview |
| SHOW FUNCTIONS | https://docs.snowflake.com/sql-reference/sql/show-functions |
| SHOW USER FUNCTIONS | https://docs.snowflake.com/sql-reference/sql/show-user-functions |
| data sharing | https://docs.snowflake.com/user-guide/data-sharing-gs |
| SHOW GRANTS | https://docs.snowflake.com/sql-reference/sql/show-grants |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#java |
| REMOVE command | https://docs.snowflake.com/sql-reference/sql/remove |
| external access integrations | https://docs.snowflake.com/sql-reference/sql/create-external-access-integration |
| network rules | https://docs.snowflake.com/sql-reference/sql/create-network-rule |
| secrets | https://docs.snowflake.com/sql-reference/sql/create-secret |
| external access integration | https://docs.snowflake.com/sql-reference/sql/create-external-access-integration |
| Using the external access integration in a function or procedure | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-using-udf |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#python |
| Python user-defined aggregate functions | https://docs.snowflake.com/developer-guide/udf/python/udf-python-aggregate-functions |
| Using third-party packages | https://docs.snowflake.com/developer-guide/udf/python/udf-python-packages |
| external access integrations | https://docs.snowflake.com/sql-reference/sql/create-external-access-integration |
| network rules | https://docs.snowflake.com/sql-reference/sql/create-network-rule |
| secrets | https://docs.snowflake.com/sql-reference/sql/create-secret |
| external access integration | https://docs.snowflake.com/sql-reference/sql/create-external-access-integration |
| Using the external access integration in a function or procedure | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-using-udf |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#sql |
| Memoizable UDFs | https://docs.snowflake.com/developer-guide/udf/sql/udf-sql-scalar-functions#label-udf-sql-scalar-memoizable |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#scala |
| REMOVE command | https://docs.snowflake.com/sql-reference/sql/remove |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#access-control-requirements |
| role | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-overview-roles |
| privileges | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-overview-privileges |
| CREATE EXTERNAL ACCESS INTEGRATION | https://docs.snowflake.com/sql-reference/sql/create-external-access-integration |
| Creating a secret to represent credentials | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-secret |
| Using the external access integration in a function or procedure | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-using-udf |
| Creating a secret to represent credentials | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-secret |
| Using the external access integration in a function or procedure | https://docs.snowflake.com/developer-guide/external-network-access/creating-using-external-network-access#label-creating-using-external-access-integration-using-udf |
| Creating custom roles | https://docs.snowflake.com/user-guide/security-access-control-configure#label-security-custom-role |
| securable objects | https://docs.snowflake.com/user-guide/security-access-control-overview#label-access-control-securable-objects |
| Overview of Access Control | https://docs.snowflake.com/user-guide/security-access-control-overview |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#general-usage-notes |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#all-languages |
| masking policy | https://docs.snowflake.com/sql-reference/sql/create-masking-policy |
| User-defined functions in a masking policy | https://docs.snowflake.com/user-guide/security-column-intro#label-security-column-intro-udf-policy |
| CURRENT_DATABASE | https://docs.snowflake.com/sql-reference/functions/current_database |
| CURRENT_SCHEMA | https://docs.snowflake.com/sql-reference/functions/current_schema |
| Metadata fields in Snowflake | https://docs.snowflake.com/sql-reference/metadata |
| ALTER FUNCTION | https://docs.snowflake.com/sql-reference/sql/alter-function |
| CREATE OR ALTER FUNCTION | https://docs.snowflake.com/sql-reference/sql/create-function#label-create-or-alter-function-syntax |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#java |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#javascript |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#python |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#scala |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#sql |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#create-or-alter-function-usage-notes |
| Preview Feature | https://docs.snowflake.com/release-notes/preview-features |
| ALTER FUNCTION | https://docs.snowflake.com/sql-reference/sql/alter-function |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#examples |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#java |
| examples | https://docs.snowflake.com/developer-guide/udf/java/udf-java-cookbook#label-udf-java-examples |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#javascript |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#python |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#scala |
| Scala UDF handler examples | https://docs.snowflake.com/developer-guide/udf/scala/udf-scala-examples |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#sql |
| ¶ | https://docs.snowflake.com/en/sql-reference/sql/create-function#create-and-alter-a-simple-function-using-the-create-or-alter-function-command |
| Visit Snowflake | https://www.snowflake.com |
| Join the conversation | https://community.snowflake.com/s/ |
| Develop with Snowflake | https://developers.snowflake.com |
| Share your feedback | https://docs.snowflake.com/feedback |
| Read the latest on our blog | https://www.snowflake.com/blog/ |
| Get your own certification | https://learn.snowflake.com |
| Privacy Notice | https://www.snowflake.com/privacy-policy/ |
| Site Terms | https://www.snowflake.com/legal/snowflake-site-terms/ |
| Snowflake Python APIs | https://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview |
| Snowflake REST APIs | https://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api |
| Snowflake CLI | https://docs.snowflake.com/developer-guide/snowflake-cli/index |
| Syntax | https://docs.snowflake.com/en/sql-reference/sql/create-function#syntax |
| Variant syntax | https://docs.snowflake.com/en/sql-reference/sql/create-function#variant-syntax |
| Required parameters | https://docs.snowflake.com/en/sql-reference/sql/create-function#required-parameters |
| Optional parameters | https://docs.snowflake.com/en/sql-reference/sql/create-function#optional-parameters |
| Access control requirements | https://docs.snowflake.com/en/sql-reference/sql/create-function#access-control-requirements |
| General usage notes | https://docs.snowflake.com/en/sql-reference/sql/create-function#general-usage-notes |
| CREATE OR ALTER FUNCTION usage notes | https://docs.snowflake.com/en/sql-reference/sql/create-function#create-or-alter-function-usage-notes |
| Examples | https://docs.snowflake.com/en/sql-reference/sql/create-function#examples |