In order to preserve the format of the CREATE VIEW statement, **Context(‘formatted’=’yes’) **has to be added to the VQL statement.
If I want to preserve the format automatically, I would navigate to the **VQL** tab of the created view to manually edit the VQL using the **Edit icon** option and save the changes. By performing this action, I could see that the Virtual DataPort Administration Tool automatically adds the CONTEXT parameter **‘formatted’=‘yes’** to preserve the VQL of the view.
You can take a look at the **[CONTEXT Clause](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/queries_select_statement/context_clause/context_clause#context-clause)** section of the Virtual DataPort VQL Guide.
Hope this helps!