Here is our use case.
The problem is that the SQL Server “Remote Host Port” does not allow configuration based upon a User Attribute, yet we need this single connection to be able to access multiple hosts.
As yet, we’ve been told this can’t be done, but we haven’t had an explanation of why it can’t be done. Is this simply a limitation in the current UI? Is this something fundamental about using an SSH tunnel (by the way, we can configure a single tunnel to talk to multiple servers)?
This just seems to be so basic. That is, have a single Looker instance with a common connection to SQL Server, where both the SQL Server Host and SQL Server Databasename can be set via User Attributes. Why, exactly, can this not be done?
Thanks!