Error: view_name.field_name No Longer Exists on explore_name and will be Ignored

This yellow warning message can pop up in an Explore or a Look. At the fundamental level, this warning indicates that fields (columns) you had previously selected and/or saved in the Explore or Look are now no longer available to the Explore. One of several conditions can trigger this message:

• The field or fields exist only in Development Mode, and you're viewing the Explore or Look in Production Mode (or vice versa).

• A join was removed from the Explore, which removed the referenced view_name.field_name from the Explore.

  For example, the error may say: "users.name no longer exists on Companies, and will be ignored." This could indicate that the users view and its fields are no longer joined in and are therefore inaccessible by the Companies Explore.

  Starting in Looker 7.20, you can use the metadata panel in the IDE to see all Explores that use a view.

• A change was made to the view's name in its file, or the view reference was changed with an explore parameter, such as view_name.

  For example, an underlying view for an Explore called users was updated from the users view to reference a view called customers with a view_name parameter:

          explore: users {
              view_name: customers
          }
      

If the field was deleted on purpose, follow the steps below to resolve the error:

1. Click the Edit button in the top right corner to edit the Look.
2. Once in Edit mode, click the x next to each error message to clear the warning.
3. Make a change, such as adding any field from the field picker and then removing it, to activate the Save button.
4. Click Save.

This will update and save the Look to omit the deleted field or fields and the accompanying errors.