Forum Discussion
carlton7372
Helper III
Helper IIIUnable to Create Table in LakeHouse Database with SSMS
Hello Community, I have just created a LakeHouse database in Fabric, whenever I attempt to CREATE a Table with SSMS I get the message Msg 368, Level 14, State 1, Line 1 The external policy ...
Hi carlton7372
If you want to add new tables to a Lakehouse, you’ll need to:
- Use the Lakehouse UI in Fabric >>Create a new table and then load data (via upload, drag-and-drop, or dataflows).
- Ingest data programmatically using Data Factory pipelines, Notebooks, or Spark in Fabric these can create and populate tables in your Lakehouse storage.
SSMS can connect to the SQL endpoint for read/query purposes only. All schema changes must be done through Fabric’s native tools or supported ingestion methods.
Hi carlton7372
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.