Forum Discussion

n_campbell's avatar
n_campbell
Regular Visitor
11 months 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
suparnababu8's avatar
suparnababu8
Super User
11 months ago

Hi n_campbell 

 

I tried in both lakehouse and warehouse sql analytics end points. it is giving the result as 11. Seem like it's defect. 

Let's wait for reply from CST team.

 

Thanks for bringing this into community.

 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!