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?
Hello ktscott
You did not mention which database type you are using (BigQuery and Snowflake strike me as having relating to this question).
In any case, what you describe sounds like the intended use case for the Looker's connection parameterization. Please start by reviewing the Database connection section of the user attributes page, and provide a follow up if the path from there is unclear.
I hope this helps.
- Kevin