Configuring Looker for many single tenant data sources

We currently store client data in a single Looker database, and use a single connection to serve data to clients. We are moving to a multi tenant database model in our data warehouse, where each client will have their own database. The schemas will be the same across all databases. Is there a way to configure a data source dynamically based on user information such that we are able to use the same models and a single connection to our data warehouse, but dynamically select from the proper database on that connection? If not, how would this be achieved in Looker?

0 1 109
1 REPLY 1
Top Labels in this Space