CODEWITHSUNDEEP
azure-sql-databaseexternal-tablesazure-synapserole-based-access-controlazure-service-principal
user961
user961

Reputation: 713

Azure Synapse - Unable to create External table Error 401 Unauthorized

I have a service principal using which I am trying to create an external table for Azure Data lake gen1. The external table creation fails with the error:

Error occurred while accessing HDFS: Java exception raised on call to HdfsBridge_IsDirExist. 
Java exception message:
HdfsBridge::isDirExist - Unexpected error encountered checking whether directory exists or not:
IOException: Server returned HTTP response code: 401

What I understand is that this is unAuthorized error. But I checked that this Service principle has proper role assignment in the Azure Data Lake Gen1 storage. What else could be causing the unauthorized issue here ? Does my SQL synapse instance where I am creating the external table also needs access to ADLS Gen1?

Please note that SQL Synapse instance and ADLS Gen1 instance are in different resource groups.

Upvotes: 0

Views: 892

Answers (1)

user961
user961

Reputation: 713

Just checked the Service principle I was using to create database scoped credentials, its secret had expired based on some periodic schedule. Renewed the secret and using the updated value helped fixing the issue.

Upvotes: 0

Related Questions