Hi @ashishasr ,

Yes, support for stored procedures is in public preview:

CREATE PROCEDURE | Databricks on AWS

In the definition of stored procedure you can use compound statement ( SQL compound statement (BEGIN ... END) with the definition of the SQL Procedure.)

And inside compound statement you can use while statement:

WHILE statement | Databricks on AWS