snowflake-create-function

SkillDatabases & data

Consult Snowflake CREATE FUNCTION parameter reference before generating any CREATE FUNCTION DDL.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the snowflake-create-function skill

What this skill tells your AI

The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-function/SKILL.md and read by ahel’s review.

Before writing a CREATE FUNCTION statement:

Read references/parameters.md to review all available parameters and their defaults.
For each parameter, decide whether the user's request implies a non-default value.
Include only the parameters that differ from the default or that the user explicitly requested.
Never use CREATE OR REPLACE — always use CREATE FUNCTION IF NOT EXISTS where supported.
Select the correct LANGUAGE clause (SQL, JAVASCRIPT, PYTHON, JAVA, SCALA) based on the user's intent; when the language is ambiguous, prefer SQL for simple transformations and Python for complex logic.
For tabular UDFs use RETURNS TABLE (col_name col_data_type [, ...]) instead of a scalar return type.
Python UDFs require an explicit RUNTIME_VERSION; Java and Scala UDFs require a HANDLER pointing to the class/method.
Place optional arguments (those with DEFAULT values) after all required arguments in the signature.
Use RETURNS NULL ON NULL INPUT (STRICT) when the function has no meaningful behavior on NULLs, to avoid unnecessary invocations.

Advanced