Skip to main content
Version: v2

Generate View

If you want to understand the differences and concepts between View and Materialized View, you can refer to here.

Dump View

After you enter the SQL statement you want in SQL Editor, you can press the drop-down menu to select View, and the system will transform your current SQL into a View.

14_sql_editor

Store the View

After clicking View, it will have a form for you to fill in the name of the storage View you want, etc.

15_sql_editor

Check the View list in SQL Editor after saving

After saving, you can expand the View list in the sidebar of the SQL Editor, and you can see the View that has just been created.

View SQL Statement

Info

This feature is only available after version 2.1.3

In the sidebar, hover the view that has been created, and select View SQL Statement in the menu.

You can then view the SQL statement of the view.

35_sql_editor

View in the data catalog

For the created View, you can switch to the data catalog, find this created View in your workspace, and edit and apply Metadata.

17_sql_editor