topic Re: Viewing/Editing of SQL Views in Data Warehouse

Viewing/Editing of SQL Views

NotebookEnjoyer — Thu, 15 Jan 2026 10:39:59 GMT

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? All that I found so far indicates that both isn't possible, but I want to be sure, because it seems so impractical.

Thanks for any help!

Re: Viewing/Editing of SQL Views

v-achippa — Thu, 15 Jan 2026 12:12:36 GMT

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

Re: Viewing/Editing of SQL Views

rizalard0684 — Sun, 18 Jan 2026 09:43:39 GMT

In short NotebookEnjoyer you are correct.

In Fabric Warehouse, there is no UI option to view or edit a SQL view’s definition directly from the object.

You can see the SQL definition only via T‑SQL (for example using sys.sql_modules or sp_helptext), and you can edit it only by running a new CREATE OR ALTER VIEW statement in the SQL editor.

There is no setting or permission you’re missing, I believe it’s a current platform limitation.

If this helped, please consider giving a Kudos or Mark my post as a solution!

Re: Viewing/Editing of SQL Views

stoic-harsh — Sun, 18 Jan 2026 14:36:09 GMT

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.

Re: Viewing/Editing of SQL Views

v-achippa — Thu, 22 Jan 2026 06:59:10 GMT

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

Re: Viewing/Editing of SQL Views

smeetsh — Fri, 13 Feb 2026 00:37:03 GMT

This is the easiest way to do it, it is very much like the sql function alter view, here it is just combined.