Dynamic Connections for Models

[dkline]

Is there a way to dynamically change a connection in a model so that we can take advantage of Snowflake secure views. Basically, in our Snowflake instance we will have secure views for each customer’s data and depending on the Looker user or group we want to use a different connection into the warehouse so that we can restrict access at the warehouse level. I know that I can only use one connection in a model and I can duplicate the models for each customer and have different connections; however, that will quickly become a maintenance nightmare. I would prefer to dynamically switch the connection so that the data reflects the correct secure view.