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.
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.
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 consists of the following types of files:
- One or more model files that define the project’s Explore options and joins
- Multiple view files, each corresponding to a database table or derived table
- One or more dashboard files which define the data and layouts for dashboards, if you choose to use LookML Dashboards instead of or in addition to User Defined Dashboards
You can access LookML projects from the Develop navigation menu:
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.
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.
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
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.
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.