name: snowflake-create-data-metric-function description: Consult Snowflake CREATE DATA METRIC FUNCTION parameter reference before generating any CREATE DATA METRIC FUNCTION DDL. metadata: version: "1.0.0"
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.