Hello @Kaniz Fatma​. Thank you for your prompt reply. I have already read these articles. However my question is if there is a way to create an SP in Databricks and not call one through a jdbc connection. Thanks again

Any updates on this? Are SPROC like features expected in the future? Or do stored SQL queries have all the same functionality? I know we can call those remotely. Thanks!

Thanks it's also helpfull to me​

Is there a way to query Databricks using Power BI, via a stored procedure or similar? In my use case the query will have multiple parameters, that the user will provide values for at runtime. I don't think notebooks can be consumed directly from Power BI, but I could be wrong.

Thanks for any help on this.

I have recently went through a video link from databricks which says its possible. But, when I tried it, it did not worked.
https://www.youtube.com/watch?v=f4TxNBfSNqM

Was anyone able to create stored procedure in databricks ?

This feature is currently in Private Preview. Please reach out to your account team and they can sign you up for it.

@twole do you know when this can be generally available? 

Looks like Stored procedures are in Public preview now. But when I am trying to create a procedure as per Databricks documentaion, it still doesn't seem to work.

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-create-pro...

can anyone help?

sample code:

CREATE PROCEDURE print_hello()
LANGUAGE SQL
SQL SECURITY INVOKER
AS BEGIN
SELECT 'Hello!';
END;

Error:

Appreciate your help!!

Thanks,

Andolina

@Andolina1 - As others mentioned, only available in DBR 17.0 which is currently in Beta in Azure.  I received the same error as you during testing and changing the cluster runtime will address it.  Probably a little early to start using at scale until 17.0 moves out of Beta.

Hi @Andolina1 this is supported in DBR 17.0 and above. 

I am able to create one with the 17.0 beta DBR version. Please refer to this: https://docs.databricks.com/aws/en/release-notes/runtime/17.0#sql-procedure-support

Its working for me without any issues if we create a cluster with DBR 17.0 

https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-procedure

how to connect the stored procedures to power bi report builder, seems like it is not working