Stored procedures

MatrixOne v4.2.5 supports SQL and Starlark stored procedures. Store reusable, parameterized business operations in the database and invoke them with CALL. SQL procedures support local variables, conditions, loops, and IN/OUT/INOUT parameters; Starlark procedures can combine language computation with mo.sql().

Use them to reuse batch-processing steps, manage related writes, and maintain ingestion watermarks. A procedure runs when called; scheduling requires a native SQL Task or an external scheduler. Bodies use string syntax, so validate compatibility when migrating MySQL procedures.