I am in a position where my Metabase instance has access to any database only via an SSH Tunnel. I can't use H2. So I need my metabase use the MySQL DB as it's application database. This MySQL database is behind SSH. Is it possible to do such a thing?
From what I read, SSH Tunneling is possible only for DBs which need to be analyzed by Metabase.
Hi @its-me
Yes, since you would create the tunnel on the host running Metabase, which essentially means that your application database environment variable would just be pointing to localhost tunnel port. https://www.metabase.com/docs/latest/databases/ssh-tunnel
From a performance/latency stand, this isn't great. The application database should be as close to Metabase as possible.