Operation on target Databricks_Transformation_Operation failed: Invalid access token.

Vaibhav Patil 20 Reputation points
2024-03-27T11:20:20.56+00:00

I encountered an error in my Azure Data Factory pipeline during the copy data activity completion. Subsequently, when transitioning to the transformation stage in a Databricks notebook, I encountered the following error:. Interestingly, the pipeline was previously functioning correctly with identical code. Upon manual execution, the issue was resolved, but it consistently fails during scheduled runs.

Error String:
Operation on target Databricks_Transformation_Operation failed: Invalid access token.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,494 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 25,881 Reputation points Microsoft Employee
    2024-03-27T20:06:09.81+00:00

    Hello Vaibhav Patil

    The error message "Invalid access token" suggests that the access token being used in your Azure Data Factory pipeline for the Databricks transformation operation is either expired or incorrectly configured.

    also, please check if you have any conditional access policy that could be causing this issue.

    I hope this helps.

    1 person found this answer helpful.