Error: Failed To Read Databricks Cluster/SQL Endpoint Information (403, Unknown)

Issue

Connection setup tests fail. The following error appears:

Check cluster configuration: Failed to read Databricks cluster/SQL Endpoint information. Error: The action failed after 4 attempt(s), the failures were: 1) java.util.concurrent.ExecutionException: java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.

Environment

• Destination: Databricks
• Authentication type: Databricks personal access token authentication

Resolution

To resolve this issue, do the following:

1. In Databricks, create a new personal access token for your Databricks workspace user. For more information, see Databricks' personal access token authentication documentation.
2. In Fivetran, go to your Databricks destination page.
3. Click Actions and then click Edit connection details.
4. Enter the new Personal Access Token.
5. Click Save & Test.