How to fix model configuration errors

One of the errors you may encounter when you validate your LookML is Model <model_name> is not allowed to use connection <connection_name>.

This error means that you need to look at the LookML project settings and verify that the model has the necessary and correct permissions to reference the connections it needs.

For example, the following error indicates that the model lauren_ecommerce is not allowed to use the athena connection:

There are two ways to fix the error:

  • Changing the connection referenced in the model file's connection parameter
  • Editing the project's configuration settings to provide access to the connection

This page provides instructions for editing the project's configuration settings.

Editing the model's configuration settings

To edit the model's configuration settings:

  1. Expand the validation error in the IDE.
  2. Select the Manage Projects link in the error message. This will take you to the LookML Projects page.

    You can also navigate to the LookML Projects page by using the URL https://<your_looker_domain.com>/projects, or by selecting Projects from the Develop menu in the left navigation panel.
  3. On the LookML Projects page, find the model that triggered the error. In this example, look for the lauren_ecommerce model for the l_ecommerce project. The model will be made more visible by a critical error in red: Manage Projects page with the lauren_ecommerce model highlighted.
  4. Select the Configure button to open the Edit Model Configuration page.
  5. Review the connections currently selected for the model in the Allowed Connections section. In this example, the error states that model 'lauren_ecommerce' is not allowed to use connection 'athena'. The connection athena is not selected in the model's Allowed Connections. The ecommerce_demo connection was selected by mistake in this case:

  6. Check the box next to the correct connection — in this case, athena. Alternatively, you can select the All option to grant the model access to all connections, including new connections added in the future.
  7. Adjust other connection selections as needed.
  8. Select Save.
  9. Navigate back to your LookML model and re-validate to verify that the model configuration error is no longer there: LookML validation result in the IDE showing no LookML errors.