Connect to multiple databases with single model and PDT?

  • 26 February 2018
  • 3 replies


We are going for a revamp of our Looker project structure.


We are connecting Looker reports to our main application via SSO embedding.

We have many customers and each customer has the same table structure defined in a different database.

Current Structure:

Each model has a list of reports which are available to be viewed. It also includes the base.lookml containing the definition for all the views which are joined as detailed in the discourse document below:

Pain Point:

We have to replicate models for each customer to have separate connections pointing to the right database. We are expecting many new customers to come on board soon. Hence, adding a new model each time a new customer joins will not be feasible.

We understand that the connection can be parametrized but with that PDT’s will not work. This is a concern for us since, we would like to use PDT’s for caching and performance purposes.

We are stuck, any direction on how to proceed with the project structure is welcomed.

3 replies

Until now, almost an year, this thread doesn’t have a solution or an answer. That a shame !

Hi @gilson.keyrus

We worked with the above customer on a workaround for his use case via email. But, thanks for flagging this thread.

This feature is currently not possible in Looker, I can pass your feedback to the product team on this. As a workaround, we can make use the Extends functionality, there is an interesting example on how we extended a model file here.

Please let us know if you have any questions in this.


@Sara_Guzman I wanted to look at the use case of extending a model file for DB connections .The link you provide to “Welcome to Looker Community”.Can you please mention the correct link please