Forum Discussion
Edit/update a datawarehouse table data
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?
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 TeamIf 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!
5 Replies
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 TeamIf 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!Thanks. I have submitted an idea for this.
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?
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.
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.
