Forum Discussion

VickyDev18's avatar
VickyDev18
Advocate II
2 years ago
Solved

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 creatin...
data warehouse
Warehouse
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!