You are viewing documentation about an older version (1.4.0). View latest version

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.