Managed Service Identity authentication is only supported by abfss file scheme

[taiwoai]

Hi

I keep getting this error anytime I execute the manifestToSQL script on the azure function app

NB: I have setup the the AzureWebJobsStorage__accountName with the value as the storage account name in the Configuration but for some wired reasons, the CREATE external table script failed.

I can establish that the function app can access the manifest, just the external table creation failed

[edjaja-olr]

Did you try to create the external table in Synapse serverless pool or dedicated pool?

[taiwoai]

Eventually got this to work, had to use the adlss link rather than the https link to the manifest file