Forum Discussion
JDBC driver does not return stored procedure or function metadata from Lakehouse end point
A fabric dwh is designed to behave like a full-fledged SQL db with full metadata support. That is why calls like DatabaseMetadata.getProcedures or getFunctions return metadata properly. A Lakehouse SQL endpoint, while it supports the definition and execution of scalar/tabular functions and stored procedures, does not currently expose the metadata through the JDBC driver. This is not clearly documented, but it is consistent with the current state of the Lakehouse endpoint, which is optimized for querying Delta tables and less for providing metadata introspection.
It appears to be either a limitation of the Lakehouse JDBC metadata support or an incomplete implementation. There is no official public documentation stating this explicitly, but Microsoft Fabric’s engineering notes indicate that metadata enumeration is fully implemented for Warehouses but partially implemented for Lakehouses.
Possible workarounds:
- Use Fabric Warehouse if you need metadata discovery at runtime.
- Query INFORMATION_SCHEMA.ROUTINES or INFORMATION_SCHEMA.PARAMETERS tables directly if they are accessible in the Lakehouse endpoint for your use case.
Please 'Kudos' and 'Accept as Solution' if this answered your query.
Hi n_campbell,
Thanks for reaching out to the Microsoft fabric community forum. This is a current limitation of the Lakehouse SQL endpoint, procedure/function metadata isn’t surfaced through the "JDBC DatabaseMetaData" APIs yet. That’s why your Warehouse call works but the Lakehouse one doesn’t. As Vinodh247 responded to your query and explained in detail why lakehouse SQL endpoint doesn't expose the metadata through the JDBC driver. Kindly go through his response and check if it answers your query.
I would also take a moment to thank Vinodh247, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Hi n_campbell,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround so that other users can benefit as well. And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi n_campbell,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.Best Regards,
Hammad.
Hi n_campbell,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.Best Regards,
Hammad.