Creating a View

Views are created by using CREATE VIEW statements in Compass through Compass UI, along with other interfaces such as API and JDBC driver. To create a view in Compass UI:

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