Create scripts in Lakehouse

Create scripts 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 the model page, click Scripts.
  5. In Scripts, click Create new.
  6. In the Create a Script page, specify the basic information:
    Name
    Specify the script name. The save option is enabled only once you have provided a script name.
    Description
    Specify script description.
  7. In the query editor section, you can create a script query manually. To list manual queries, click Format.
  8. Optionally, to load queries from the Lakehouse existing models or parameters, expand an available model or parameter 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 Validate.
  10. Click Save.