Forum Discussion
Connecting to fabric SQL endpoint from SSMS
Hi, I'm unable to connect to my fabric SQL endpoint from SQL Server Management Studio. This is supposed to be possible right? Error message below. Anyone know what I need to get this working? ...
Hello!
From the error message it appears you are executing an INSERT command in a lakehouse, which is not supported. Lakehouse SQL Endpoint only allows SELECT queries. To modify data you need to create flows using dataflows and pipelines or use commands directly in Spark notebooks.
What is SQL endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
To perform DML operations use warehouses instead of lakehouses.