Forum Discussion

NotebookEnjoyer's avatar
NotebookEnjoyer
Advocate II
7 months ago
Solved

Viewing/Editing of SQL Views

Hello everyone, if I create a SQL view in my warehouse, is there an option to review it's formula (from the view itself, not because I kept it somewhere else)? And in the same vein, can I edit it? A...
data warehouse
Warehouse
  • stoic-harsh's avatar
    stoic-harsh
    7 months ago

    Hi NotebookEnjoyer,

     

    You can use Download SQL database project to export a compressed copy of your entire Warehouse or Lakehouse and access all view definitions.

     

    In addition to the solution suggested by rizalard0684, another quick UI-based option is to use Query Activity (see screenshot). It shows all recently executed queries along with imp details like duration, run count, and success/failure status.

     

     

    For scalability, I would recommend creating views via Stored Procedures (editing views would be much simpler, this way). Think of them as warehouse-specific pipelines. You can even manage multiple view definitions within a single stored procedure.

v-achippa's avatar
v-achippa
Community Support
7 months ago

Hi NotebookEnjoyer,

 

Thank you for reaching out to Microsoft Fabric Community.

 

This is expected behaviour in the fabric warehouse. There is no UI option to view or edit an existing sql view definition. Views cannot be edited directly they must be recreated using CREATE OR ALTER VIEW. This is a current product limitation.

If this capability is important, please consider submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

Fabric Ideas - Microsoft Fabric Community

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Community Support
    7 months ago

    Hi NotebookEnjoyer,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if you have raised this in the ideas forum?

     

    Thanks and regards,

    Anjan Kumar Chippa