Azure synapse writing data with Databricks using polybase error

[SivakrishnaSunk]

We are writing the data from Delta tables to Azure synapse using Azure Databricks. While loading the data into the synapse staging table getting an error " HdfsBridge::CreateRecordReader - Unexpected error encountered creating the record reader: abfsrestoperationexception: operation failed: "server failed to Authenticate the request". It is occuring while reading the polybase Parquet file.. Can some one advice about the error and any resolution?

[jose_gonzalez · Accepted solution]

Hi SivakrishnaSunkara,

You will find more information and example in the following link url https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/azure/synapse-analytics please follow the steps fro the authentication section to avoid this error message.

Thank you.