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.
rohit1991
Super User
Super UserHi 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.