Edit Materialized View
Materialized Views are immutable after they are deployed. This ensures your data will remain correct throughout the entire history and will prevent unexpected results for queries. However, you can still edit a materialized view by cloning it.
How To Clone And Edit A Materialized View
- From the drop-down menu next to the Run/Stop button click Duplicate.
- Name your duplicate view and click Duplicate to confirm.
- You can now edit your materialized view in the same manner you did when creating it.