Forum Discussion
Edit/update a datawarehouse table data
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!
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.