SQL Stored Procedure in Databricks

ashishasr — Tue, 30 Sep 2025 12:00:37 GMT

Hello, Is there a sql server equivalent stored procedure in Databricks which supports while loop along with delay as below. or are there any other alternative to achieve the same.

while (select count(*) from schema.mart_daily with (nolock)) = 0 begin waitfor delay '00:01' end

Thank You in advance.

Re: SQL Stored Procedure in Databricks

szymon_dybczak — Tue, 30 Sep 2025 12:37:42 GMT

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

topic SQL Stored Procedure in Databricks in Data Engineering

SQL Stored Procedure in Databricks

Re: SQL Stored Procedure in Databricks