| name | snowflake-create-data-metric-function |
| description | Consult Snowflake CREATE DATA METRIC FUNCTION parameter reference before generating any CREATE DATA METRIC FUNCTION DDL. |
Before writing a CREATE DATA METRIC 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 DATA METRIC FUNCTION IF NOT EXISTS where supported.
- The function body must be a deterministic SQL expression that returns a scalar NUMBER; avoid nondeterministic functions such as CURRENT_TIME or RANDOM.
- The table argument signature must list every column that the expression references; all listed columns must belong to the same table.
- Mark the function
SECURE when the expression logic or column names would reveal sensitive business rules to non-owner roles.
- Use
$$ delimiters for the AS clause when the expression body contains single-quote characters.
