Could any one please suggest how to access Storage account files from a dedicated sql pool via External tables from SQL USER login. I am able to access data from Azure AD user. But unable to do the same from SQL User.
I have tried to CREATE CREDENTIAL for my DataLake with SAS. But got an error saying - 'CREATE CREDENTIAL' is not supported in this version of SQL Server.
Version is : Microsoft Azure SQL Data Warehouse - 10.0.13727.0 Mar 12 2022 08:05:11 Copyright (c) Microsoft Corporation