home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Accessing and Editing Project Information

This page assumes you have created a project or are working with an existing project. This page explains how to rename a project and make other changes to a project.

The LookML Projects page includes the following basic categories:

Accessing Project Files

You can access project files either from the Develop section in Looker or from the UI.

Accessing Project Files from the Develop Menu

You can access project files by going to the Develop navigation menu and selecting the project you would like to view. This will take you to the LookML file browser page.

Project files are shown in the side panel of the Looker IDE. LookML developers can customize the file organization to match your project, as described on the Working with Folders in the IDE documentation page.

You must be in Development Mode in order to edit files.

  1. Click Develop to open the Develop menu.
  2. Click the project you want to access.
  3. In the file browser panel, click the file you want to access.
  4. Click the information icon to open the quick help panel, which provides explanations and options for the current location in the code. You also can click a parameter name in the sidebar to go to Looker documentation for that parameter.

Searching for Project Files

Looker provides an integrated development environment (IDE) for creating and managing your project files. The IDE is often referred to as the LookML editor as that’s where you edit LookML files.

In the Looker IDE, you can search for and open a project file using the keyboard shortcut Command-J (Mac) or Ctrl+J (Windows), or by clicking the Search Files icon to search for a project file:

This opens the search window:

  1. In the Search Files field, enter a search term. The search term can be a word or any part of a word.
  2. The file list will show only those files that include your search term. The results show each file’s name and file type. Click the file you want to open.

Accessing LookML from an Explore

You can also directly access the LookML for an Explore or a field from an Explore. This can be done in several ways:

  1. To see the LookML for an Explore, click on the Looker icon near the Explore name.
  2. To see the LookML for a field in the field picker, open the field’s gear menu in the field picker and select Go to LookML.
  3. To see the LookML for a field in the results table, open the field’s gear menu in the table header and select Go to LookML.

After selecting a field, you will be taken directly to the field definition in the corresponding LookML file.

Accessing LookML from the Object Browser Panel

You can use the object browser panel to view all the objects in your project or to navigate to the LookML for a specific object. To use the object browser panel, select the object browser icon below the folder icon in the Looker IDE. You can then navigate to the LookML for an object by selecting the name of the object in the object browser panel. When you select an object, the IDE takes you to the file in which the object is defined and positions your cursor on the first line of the object’s declaration:

For more information, see the Navigating Projects with the Object Browser Panel documentation page.

Existing Projects and Their Models

To view existing projects on the LookML Projects page, click the Develop menu and choose Manage LookML Projects.

In the top section of the LookML Projects page, you can see certain existing projects. In Production Mode, you see projects that have been generated and pushed to production. In Development Mode, you see projects that you have pulled from production or generated yourself in your Development Mode.

To see a project, you must have the manage_models permission, or have the develop permission for at least one model in the project.

If you have the manage_models permission, you can add or edit the configuration for any model listed under the projects.

To specify a new project or a new model for an existing project, see the Creating a New LookML Project documentation page.

Viewing the Listing for a Project

Below you can see an example of the project listings on the LookML Projects page. Each element of a project listing is described below.

Project Name

This is the name of the project. Each project may have one or more models listed next to it. You can click on the project name to navigate to the LookML for that project. If the project uses the older YAML-based LookML, that is indicated next to the project name.

Models

This is the set of LookML model files for the given project.

If your Development Mode environment differs from production, this list can change between Development Mode and Production Mode. For example, if you might have created a new model in Development Mode that you have not yet pushed to production.

Configuration Issues

If there is a problem with a model, the model will show a status indicating the problem with the configuration.

Issue Explanation
LookML model file doesn’t exist yet You see this issue if someone configured a model on this page but has not yet created a corresponding LookML file for it.
Configuration required for use You see this issue if someone created a new LookML model file in an existing project, but has not configured it on this page yet.
Connection ‘x’ does not exist The connection declared in the model file does not exist (such as if someone misspelled it or has not created it yet).
Model ‘x’ is not allowed to use connection ‘y’ The connection declared in the model file is not permitted according to the configuration on this page.
A model named ‘x’ is already configured in project ‘y’ Model names must be unique within your Looker instance, even if they are in different projects.

Configure Button

If the Configure button is available next to the project’s listing, you can add or edit the project’s model configuration.

Viewing the Listing for a Marketplace Project

The Marketplace Projects section of the LookML Projects page lists projects that were created during the installation of a Marketplace application, block, or plug-in. The listing for each Marketplace project includes the following elements:

Adding and Editing Configurations

If the Configure button is available next to the project’s listing, you can add or edit the project’s model configuration.

If the model does not have a configuration, when you click Configure, Looker displays the Configure a Model page. On the Configure a Model page, you can specify the model name, the project name, and which connections are available to the model:

If the model does have a configuration, when you click Configure, Looker displays the Edit Model Configuration page. On the Edit Model Configuration page, you can change which connections are available to the model:

You can view the model name but not rename it. Models are named according to the filenames you use in the Models section of the Looker IDE.

In the Project field, you can specify that the model should be associated with a different project. For example, if you created a new project including a model with the same name, you can transition the model configuration to be associated with the new project’s model.

In the Allowed Connections field, you can limit the model to use a list of specific connections, or you can allow the model to use any connection (all current and future connections).

Renaming a Project

Once you have created your project, if you are a Looker admin, you can change the project name using the project’s Project Settings page.

Looker developers who are not admins can view the Project Settings page but cannot change the options there.

To rename a project:

  1. Verify that you have Development Mode turned on.
  2. In your project, select the settings icon in the IDE navigation bar to open the project settings panel.
  3. Select Configuration in the project settings panel.
  4. Use the Name field under Project Configuration to edit the name of your project.
  5. Scroll down in the Project Configuration page and click Save Project Configuration to save the new project name.

Deleting a Project

If you are a Looker admin, you can delete an existing project. Clicking the Delete Project button will remove all LookML from the project, in all development and production environments across your Looker instance.

Please be certain you want to delete a project before you do so. It cannot be undone and is difficult and laborious to recover.

A deleted project will no longer appear in the Projects section of the LookML Projects page, but will still appear in the Configured Projects section.

To remove the project configuration, which will remove the project from your development environment completely:

  1. In your project, select the settings icon in the IDE navigation bar to open the Project Settings panel.
  2. In the project settings panel, choose Configuration to see the project configuration.
  3. Under Project Configuration, select Delete Project. This will open a Delete Project window. In the Delete Project window, verify the warnings and the unsynced changes that will be lost if the project is deleted.

    You can cancel out of the operation and navigate back to your project by clicking your browser’s Back button.

  4. If you are sure the project should be deleted and you want to continue, type the project’s name in the text box.

  5. Click the Permanently Delete <project name> button.

Projects with Only a Configuration

The Pending Projects section contains models that are configured with a project name, but not yet generated.

Thus the Pending Projects section contains projects and models that are only configured, that do not yet have any LookML.

Configuring models before the project exists is useful if you have developers who have not been given the manage_models permission. Because the model has already been configured, those developers will be able to run queries as soon as they create the project and that model. When the project is generated, the listing for that project moves to the top section of the LookML Projects page.

Viewing the Listing for a Project

Below you can see an example of the Pending Projects section. The elements of this section are described below.

Project Name

This section lists projects that are configured but not yet generated, so the project name in this field is the intended name of the project when it is later generated. Clicking the project name takes you to the New Project page where you can generate that project. You must be in Development Mode to reach the New Project page.

Models

This is the model name that was specified when creating the model configuration.

Allowed Connections

The column to the right of the model name shows the connections that were allowed for this model when creating the model configuration.

Editing a Configuration

The Configuration button lets you change the project name and the connections that are permitted for this model. Click it to edit the model configuration.

On the Edit Model Configuration page, you can change which connections are available to the model. You can view the model name but not rename it.

You can also specify that the model should be associated with a different project. For example, if you created a new project including a model with the same name, you can transition the model configuration to be associated with the new project’s model.

Adding LookML to a Project

The Add LookML button opens the New Project page for that project, letting you use the LookML generator to automatically generate LookML based on a set of tables in your database.

Top