Edit/update a datawarehouse table data

[VickyDev18]

We have little config tables that need data to be updated (typically 1 row or 1 column in a row or add 1 row etc) and writing a script to update these or maintaining a separate excel and then creating a separate dataflow to pull that data seems like an overkill. 

In a SQL DB, I can just edit data in SSMS and be done with it. However, a datawarehouse table doesn't seem to support that.

Is there a way to easily update a table of data without having to write insert/update scripts?

[v-huijiey-msft · Accepted solution]

Hi @VickyDev18 ,

Thanks for the reply from frithjof_v .

As you can see in the screenshot below, I have done some testing and understand your frustration that connecting to the warehouse from SSMS does not  give you the option to edit the top 200 rows as it does when connecting directly to the database from SSMS.

Unfortunately, Fabric warehouse does not provide a GUI method, you can use Update statement.

If this feature is important to you, you can provide idea on Home (microsoft.com) and attach the link to your idea, I will give you a Vote, I believe that people who are concerned about this case or have the same need will give you a Vote.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[VickyDev18]

Thanks. I have submitted an idea for this. 

Allow ability to edit top 200 rows in a Warehouse table

[frithjof_v]

I haven't tried connecting to Fabric Warehouse in SSMS. I understand you have tried it, but it didn't allow to edit the table content in the GUI.

The closest thing I can think of is Dataflow Gen2. You can enter data directly in a Dataflow Gen2. Or connect the Dataflow Gen2 to an Excel sheet, as you mentioned.

[frithjof_v]

How do you do that in SSMS?

"In a SQL DB, I can just edit data in SSMS and be done with it. However, a datawarehouse table doesn't seem to support that."

Are you wanting to write the insert/update in SQL code, or are you looking for a GUI method to do it?

[VickyDev18]

For a SQL DB, I can right-click on a table and select Edit Top 200 rows and just edit the data or add new rows as if I would in excel. This option doesn't show up when connecting to a Fabric warehouse DB.

I am looking for a similar GUI method and not a script method.