LookML Projects and Developer Mode

LookML
Version

On this Page
Docs Menu

Projects are typically created during Looker setup, at the same time as model generation. This page assumes that you or someone else has already created a project. If your organization is just starting with Looker you may want to coordinate with your Looker Analyst to ensure project creation is done as cleanly as possible.

LookML Projects

Definition

A LookML data model is stored in one or more “projects”. A project is a collection of LookML files that describe how your database tables are related to each other, and how Looker should interpret those tables. Looker uses git for version control, to ensure that your developers can successfully collaborate on your data model. In general, one project represents a single git repository.

Looker provides an integrated development environment (IDE) for creating and managing your data model.

Project Files

When you or someone else creates a new project, Looker’s project generator creates a baseline set of files, which you use as a template for building out the project. In many cases you will not need to write a LookML file from scratch.

A project lists its files in the following categories:

  • Documents: Possibly some documentation files written in Github-flavored Markdown.
  • Models: One or more model files that define the project’s Explore options and joins.
  • Views: Multiple view files, each corresponding to a database table or derived table.
  • Dashboards: Possibly some dashboard files which define the data and layouts for dashboards, if you choose to use LookML Dashboards.
  • Data: Possibly one or more data files, which are JSON files. These files can be used to specify custom maps.
  • Other: Any file, whose filetypes are not recognized by the LookML IDE as belonging in one of the other categories. If you would like to move a file from the Other section to another section, click the file’s gear and rename the file to have the appropriate file type extension.

Accessing Projects

You can access LookML projects from the Develop navigation menu:

More Detail

Read more about managing projects here.

Development Mode vs. Production Mode

In the upper right of this page, check out our new videos about development mode.

Your Looker data model exists in two states: production mode and development mode.

Production Mode

Typically, when users explore data in Looker, they’re in production mode. In this mode, the data model they are exploring is shared across all users. The LookML files that make up the data model are treated as read-only in this mode.

Development Mode

Enter development mode when you’d like to make a change to your LookML. This mode accesses a completely separate version of your data model that only you can see and edit. (If you are familiar with Git terms, development mode is handled by a separate branch.) When you’re happy with your changes you can merge them into production and resolve any conflicts with other developers.

Development mode enables you to make and test LookML changes without affecting business users, who as mentioned above, are using production mode.

Development mode is frequently referred to as “dev mode” or “developer mode”.

Switching In and Out of Development Mode

You can switch development mode on and off by either of these methods:

  • Using the keyboard shortcut Ctrl+Shift+D
  • Clicking Develop to open its menu and then clicking the Development Mode ON/OFF button

While in development mode, you will notice the following changes:

  • The LookML and Explore sections of Looker will be populated by your development version of the model
  • There will be a purple Development Mode bar at the top of the browser window

To exit development mode, you can use any of these methods:

  • Use the keyboard shortcut Ctrl+Shift+D
  • Click Exit Development Mode in the purple banner
  • Open the Develop menu and click the Development Mode ON/OFF button

Version Control

Looker’s IDE is integrated with Git for version control. This enables you to edit a private copy of the LookML files in development mode. When you’re ready for everyone to begin using any changes you’ve made, you can use Git to Commit and Push your changes to production.

Looker automatically manages the Git workflows for committing, pulling, and pushing changes. For details on using Looker’s version control see this page.

Conclusion

Now that you know the basics of a project and how to get into developer mode, the next step is to understand the model and view files that are a part of the project.

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