SSH and Remote Host Port when using SSH tunnel

Here is our use case.

  • We are using SQL Server and clients are distributed across multiple SQL Server instances
  • We only want to maintain one version of our LookML code (connection string in the model does not change)
  • For the connection settings for this connection string, we need to use an SSH Server.
  • The SQL Server database name is controlled by an User Attribute

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!

1 2 1,586
2 REPLIES 2