Create views in Lakehouse

Create views within a Lakehouse model.

  1. From Models, select or search for an existing model.
  2. On the model's thumbnail view, click the corresponding ... menu.
  3. To create a table, select Designer.
  4. From Tables & Views, click Views.
  5. In Views, click the + icon.
  6. In the Create a view page, specify the basic information:
    Name
    Specify the view name. The save option is enabled only once you have provided a view name.
    Public
    Select this box to set the view as public.
    Description
    Specify view description.
  7. In Query editor section, you can create a view query manually. To list manual queries, click Format.
  8. Optionally, to load queries from the Lakehouse existing models, expand an available model from the right-side query pane and click the included queries to format.
    You can also use the search function to find specific available queries.
  9. Optionally, to run previews of queries, click Preview query.
  10. Click Save.