snowflake.core.function.FunctionResource¶

class snowflake.core.function.FunctionResource(name_with_args: Annotated[str, Strict(strict=True)], collection: FunctionCollection)¶

Bases: SchemaObjectReferenceMixin[FunctionCollection]

Represents a reference to a Snowflake function.

With this function reference, you can create and fetch information about functions, as well as perform certain actions on them.

Attributes

database¶

fully_qualified_name¶

root¶

Methods

delete(if_exists: bool = False) → None¶

Delete this function.

Parameters:

if_exists (bool, optional) – Whether to error if the function doesn’t exist. Default is False.

Examples

Deleting a function using its reference, erroring if it doesn’t exist:

>>> function_reference.delete()

Copy

Deleting a function using its reference, if it exists:

>>> function_reference.delete(if_exists=True)
The `delete` method is deprecated; use `drop` instead.

Copy

drop(if_exists: bool = False) → None¶

Drop this function.

Parameters:

if_exists (bool, optional) – Whether to error if the function doesn’t exist. Default is False.

Examples

Dropping a function using its reference, erroring if it doesn’t exist:

>>> function_reference.drop()

Copy

Dropping a function using its reference, if it exists:

>>> function_reference.drop(if_exists=True)

Copy

execute(input_args: List[Any] | None = None) → Any¶

Execute this function.

Parameters:

input_args (List[Any], optional) – A list of arguments to pass to the function. The number of arguments must match the number of arguments the function expects.

Examples

Executing a function using its reference:

>>> function_reference.execute(input_args=[1, 2, "word"])

Copy

fetch() → Function¶

Fetch the details of a function.

Examples

Fetching a reference to a function to print its name:

>>> function_reference = root.databases["my_db"].schemas["my_schema"].functions["foo(REAL)"]
>>> my_function = function_reference.fetch()
>>> print(my_function.name)

Copy