Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
n_campbell
Regular Visitor

JDBC DatabaseMetadata.getFunctions does not return user defined scalar functions from lakehouse

One or more scalar/tabular user defined functions are declared in a lakehouse.

Connection established via Microsoft SQL Server JDBC driver to a lakehouse end point.

When DatabaseMetadata.getFunctions is called.

It returns an empty Resultset (cannot find functions) for the specified catalog, schema (name or pattern), function (name or pattern).

Is this a known limitation/defect?

System.out.println("Get functions");
int i = 0;
try (ResultSet rsFunctions = dbMeta.getFunctions("xxyyzz", "%", "F%");) {
while (rsFunctions.next()) {
System.out.println(rsFunctions.getString(1) + "." + rsFunctions.getString(2) + "."
+ rsFunctions.getString(3));
++i;
}
}
System.out.println("Functions found " + i);


n_campbell_0-1756378787687.png

 

0 REPLIES 0

Helpful resources

Announcements
August Fabric Update Carousel

Fabric Monthly Update - August 2025

Check out the August 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.