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.

stoic-harsh's avatar
stoic-harsh
Super User
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.