Error: Failed to Read Databricks Cluster/SQL Endpoint Information (OAuth2)

Issue

Destination setup tests fail. The following error appears:

Check cluster configuration: Failed to read Databricks cluster/SQL Endpoint information. Error: The action failed after 5 attempt(s), the failures were: 1) java.util.concu rrent.ExecutionException: java.sql.SQLException: [Databricks][JDBCDriver](500663) OAuth2 is currently supported on AWS, Azure, and GPC platforms.

Environment

• Destination: Databricks
• Authentication type: OAuth machine-to-machine (M2M)

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Databricks destination page.
2. In the top right, click Actions and then click Edit connection details.
3. Make sure the Server Hostname is spelled correctly and doesn't include https://. For example, test-01.cloud.databricks.com.
4. Click Save & Test.

Cause

This issue occurs when the Server Hostname you provide while setting up your destination is invalid or incorrect. For more information on how to find your Server Hostname, see our Databricks destination setup guide.