Forum Discussion
MorenaBI
Helper I
Helper IStored procedures on Lakehouse sql endpoint
Hello, I read few few topics about it here however I have an addtional question. I can creat a stored procedure on a sql endpoint, and I can execute it from the sql endpoint but after creating it...
- Because the endpoint is not a full SQL Server instance, SSMS Object Explorer doesn’t always enumerate Lakehouse procedures under the usual Programmability → Stored Procedures node—even though the objects exist and are runnable. (Also note there’s one SQL endpoint per workspace now; each Lakehouse shows up as a separate database on that single endpoint—make sure you’re connected to the right database in SSMS.)
Thomaslleblanc
Super User
Super UserBecause the endpoint is not a full SQL Server instance, SSMS Object Explorer doesn’t always enumerate Lakehouse procedures under the usual Programmability → Stored Procedures node—even though the objects exist and are runnable. (Also note there’s one SQL endpoint per workspace now; each Lakehouse shows up as a separate database on that single endpoint—make sure you’re connected to the right database in SSMS.)
- deborshi_nag
I have tested it - seems to be working for me.
MorenaBIIt wasn't visible there. That's why I posted the question.
- MorenaBI
That's right, it seems there is an isssue with lakehouse.
