This blog highlights how to load and query using PolyBase by authenticating via Azure Active Directory (AAD) pass-through to Azure Data Lake Storage Gen2. AAD pass-through authentication with PolyBas...
Updated Apr 20, 2020
Version 3.0
Blog Post
Hi Kevin, I tried using this process, but unfortunatly I cannot get it to work.
The AAD user is owner of the datalake and sysadmin on the DW, so it should not be a rights issue - but I get this error when attempting to create the external table:
HdfsBridge::isDirExist - Unexpected error encountered checking whether directory exists or not: AbfsRestOperationException: HEAD https://<redacted>dfs.core.windows.net/transformed/<redacted>/2019?timeout=90
StatusCode=403
StatusDescription=This request is not authorized to perform this operation using this permission.
ErrorCode=
ErrorMessage='