Forum Discussion

n_campbell's avatar
n_campbell
Regular Visitor
1 year ago

T-SQL SERVERPROPERTY(EngineEdition) does not return the value 12 for Lakehouse endpoint

Need to be able to dynamically determine if an end point is referring to Lakehouse. A workspace includes a Lakehouse and a Warehouse. When the statement select SERVERPROPERTY ('EngineEdition') ...
one lake
workspaces
V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi n_campbell,

Thanks for checking and sharing this suparnababu8 . I’ve tested on both Lakehouse and Warehouse SQL analytics endpoints in Microsoft Fabric, and I’m also consistently seeing.
SELECT SERVERPROPERTY('EngineEdition') AS EngineEdition;
-- Result: 11

FYI:

 


Based on the documentation, we would expect EngineEdition = 12 for Lakehouse endpoints. Since both endpoints are currently returning 11, this appears to be either a documentation mismatch or a platform inconsistency.
For now, I’m treating this as a potential defect . In the meantime, please also consider submitting feedback through the official feedback form this will help the product team prioritize and address the issue.

 

Link: Learn about Microsoft Fabric feedback - Microsoft Fabric | Microsoft Learn

 

Regards,
Yugandhar.