Stored ProceduresΒΆ

Stored procedures in Snowpark. Refer to StoredProcedure for details and sample code.

Classes

StoredProcedure(func, return_type, ...[, ...])

Encapsulates a user defined lambda or function that is returned by sproc(), StoredProcedureRegistration.register() or StoredProcedureRegistration.register_from_file().

StoredProcedureRegistration(session)

Provides methods to register lambdas and functions as stored procedures in the Snowflake database.

Methods

describe(sproc_obj)

Returns a DataFrame that describes the properties of a stored procedure.

register(func[, return_type, input_types, ...])

Registers a Python function as a Snowflake Python stored procedure and returns the stored procedure.

register_from_file(file_path, func_name[, ...])

Registers a Python function as a Snowflake Python stored procedure from a Python or zip file, and returns the stored procedure.

Attributes

func

The Python function.

name

The stored procedure name.