Databricks: Server Failed to Authenticate the request. Make sure the value of Authorization header is formed correctly including the signature

Federico Gonzalez 5 Reputation points
2023-05-20T19:08:30.4366667+00:00

Hi,

I am taking the course 'Perform data science with Azure Databricks' in Coursera and followed the instructions to create a Workspace and cluster to being able to run the learning notebooks imported from

https://github.com/solliancenet/microsoft-learning-paths-databricks-notebooks/blob/master/data-engineering/DBC/03-Reading-and-writing-data-in-Azure-Databricks.dbc?raw=true

When trying to run the notebooks as per the course instructions, I am getting the following error: 'Server failed to authenticate the request. Make sure the value of authorization header is formed correctly including signature.

This is the first time that I am using Databricks and I have no clue on how to troubleshoot it. I've read many similar posts, but I don't know which one is relevant to my case as I believe the authentication is done via Azure credentials ?

Thanks for your help in advance :)

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,075 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee
    2023-05-22T15:13:53.31+00:00

    Hi @Federico Gonzalez ,

    Welcome to Microsoft Q&A forum and thanks for reaching out here.

    As you are following a third-party learning course, it is possible to that the content might be old or outdated (from the GitHub repo, I see the content is 2 year old) which could be a reason why you are experiencing such discrepancies.

    User's image

    As all the issues related to that repo are being reported here, I recommend logging an issue there and one of the content owners might be able to validate and update it accordingly -https://github.com/solliancenet/microsoft-learning-paths-databricks-notebooks/issues

    From the error message it is clear that authorization header is not formed correctly, which can happen if the authentication credentials are not set up correctly.

    I would highly recommend using Personal Access Token and see if that helps to establish the connection.

    For more information, kindly go follow this Microsoft public documentation: Configure the Databricks ODBC and JDBC drivers

    User's image

    Hope this info helps. Let us know how it goes.

    Thank you

    0 comments No comments