topic Re: Access RDS Postgres DB via SSH Tunnel in Get Started Discussions

Access RDS Postgres DB via SSH Tunnel

kashy — Tue, 05 Sep 2023 08:08:40 GMT

Hello,

How can I configure a foreign catalog connection to use SSH tunneling? I want to be able to use unity catalog

Debayan — Mon, 11 Sep 2023 07:53:46 GMT

Also please tag @Debayan with your next response which will notify me, Thank you!

kashy — Mon, 11 Sep 2023 08:47:42 GMT

I cannot seem to get the link to raise a support ticket - just diverts me back here!

kashy — Mon, 11 Sep 2023 08:49:57 GMT

thanks @Debayan that might work for a JDBC connection but I want to use in a foreign connection with unity catalog which this would not work with

Debayan — Thu, 14 Sep 2023 04:41:26 GMT

Hi ,

You work with foreign catalogs in the same way that you work with any catalog managed by Unity Catalog:

View information about a foreign catalog: see View catalog details.

In addition to the information that is displayed for standard Unity Catalog catalogs, Catalog Explorer also displays the Connection used by the foreign catalog and the external database or catalog that is mirrored by the foreign catalog.
Run read-only queries on tables in foreign catalogs: see Query data.

When you write queries in Databricks, you must use Apache Spark data types. For a mapping of Spark data types to your external database data types, see the article for your connection type, listed in the table of contents in the left navigation pane of this documentation site.
Grant read-only access to data in foreign catalogs: see Manage privileges in Unity Catalog.
- Get data lineage for tables in foreign catalogs: see Capture and view data lineage with Unity Catalog.
  
  To learn how to create foreign catalogs, see Create a foreign catalog.

kashy — Fri, 15 Sep 2023 16:50:56 GMT

Hi @Debayan the issue is the lack of support for ssh tunnels - there is no configuration for these on foreign catalog connections