Error: Databricks Adapter: Could Not Retrieve Saved Token

Issue

Transformations are delayed and fail with the following error:

Databricks adapter: could not retrieve saved token

Environment

• All transformations
• Destination: Databricks

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Databricks destination page.
2. In the Actions drop-down menu, click Edit connection details.
3. In the Authentication Type drop-down menu, ensure the option PERSONAL ACCESS TOKEN is selected and the personal access token you have provided is correct. See our Databricks setup guide for more information.
4. Click Save & Test.

Cause

In April 2024, we added support for the OAuth machine-to-machine (M2M) authentication type for Databricks destinations. See our Databricks release notes for more information. When we implemented the change, the configuration for some Databricks destinations automatically switched from the PERSONAL ACCESS TOKEN authentication type to OAuth 2.0, resulting in the error above.