When trying to access a Databricks Warehouse from an external workspace I get the following error.
Both, the Warehouse and the workspace are hosted on different AWS subscriptions.
But curiously, with the same script I can access the Databricks Warehouse from a workspace hosted in Azure.
I have tried and there is 443 connectivity from the workspace, but I receive this 302 HTTP error. It definitely looks like a connectivity issue, but I'm running out of ideas.
""
connecting to url [jdbc:databricks://XXXXXXXXX:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/XXXXXXX;] and table [XXXXXXXXXXX]
SQLException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 302.
Caused by: ErrorException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 302.
Caused by: TTransportException: HTTP Response code: 302
""
I appreciate any help or suggestions, thank you!!