I'm trying to connect to Databricks from Workato, to pull data in as part of a Workato Recipe. I'm getting the following error when I test the connection:
"Database bridge error: Failed since could not connect to the database - Failed to initialize pool: [Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown."
As an independent connection test, I tried connecting to the same Databricks workspace from PowerBI, with all of the same credentials, and was able to connect and retrieve data successfully.
Has anyone successfully connected to Databricks from Workato before, and if so, did you need to do any additional config to get it working? Is it possible there's a restriction applied to an iPaaS platform such as Workato that would need to be lifted?
Thanks!