Generating a Model

On this Page
Docs Menu

This tutorial walks you through the steps to create a new project and automatically generate a basic model from your database. You can also manually create a new model for an existing project

Before attempting to generate a model, ensure that you are in development mode (the toggle is at the top of the Develop menu). Click on Develop in the menu bar, then Manage LookML Projects.

In the Manage LookML Projects page, click + New LookML Project (if you’d like more detail about the Manage LookML Projects page, check out our documentation here).

Select the database connection you are interested in. If you would like to generate LookML for every table in the database, accept the default values in the form. Otherwise, customize these values.

The LookML Type field enables you to choose to use the older YAML-based LookML or the improved New LookML. You only see this field if the legacy feature to create YAML-based LookML projects is on. In release 4.4 the legacy feature is on by default and then release 4.10, the default changes to off. For information on why New LookML is better, see this article.

Now click Create Project. The generator creates a model file and view files for each table in the database (unless otherwise specified).

The generator will also create an Explore for each database table. To start querying your data, first click Explore, then select the name of the Explore you would like to start your query from.

Afterwards, you can manually create additional new models for your project as described here and then configure them for use in production as discussed here, with step-by-step instructions later on the same page.

Still have questions?
Go to Discourse - or - Email Support