Creating a view

You create views through the CREATE VIEW statements in the Compass user interface, along with other interfaces such as API and JDBC driver.

Instead of using the SELECT* statement, we recommend that you specify the name of each property from each object to include in a view.

  1. Pause on a data object in the left menu.
  2. Click the ellipsis icon.
  3. Select VIEW > Create view.
    A CREATE VIEW statement is generated in the editor.
  4. Click Run query.
    A view is created in Data Lake and its metadata is registered in the Data Catalog. After a view is created, the left panel is refreshed, and the view is listed in the Views section.