Erorr connecting to Databricks from ADF Delta Lake - Error message: Client Secret is invalid

[saiV06]

Hi,

The client secret recently expired and I updated the configuration with the new secret. From then on, I'm not able to access the data from ADF using the delta lake component, and here is the error message I keep getting:

HTTP Error 401; url='https://login.microsoftonline.com/<tenant id>/oauth2/token' AADToken: HTTP connection to https://login.microsoftonline.com/<tenant id>/oauth2/token failed for getting token from AzureAD.; requestId='<req id>'; contentType='application/json; charset=utf-8'; response '{"error":"invalid_client","error_description":"AADSTS7000215: Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID, for a secret added to app '<app id>'

I'm not sure what else I'm missing, and I'm exhausted with all options provided online. All settings seem to be matching per the recommendations. I'm able to access the data from databricks sql and it has been working perfectly fine before the expiry. Any assistance here is much appreciated.

Thanks!

[saiV06 · Accepted solution]

Thank you for your response. I was able to fix the issue. I was using the secret only and not the secret id and as well confirmed that all settings were updated. I had to unmount and remount the storage locations after updating the client secret, which resolved the issue. It doesn't make any sense to me why would this be, but this is what fixed the issue.