Hi, Josh
Unfortunately not, currently, only Azure Blob storage is supported. Based on some research, you can't use UNC paths on-premises either.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hey,
Polybase can load from blob storage, but can it access Azure File Shares directly??
Can we use CREATE EXTERNAL DATA SOURCE somehow to do that?
Hi, Josh
Unfortunately not, currently, only Azure Blob storage is supported. Based on some research, you can't use UNC paths on-premises either.
Hello Josh,
Hope you are doing well today. Yes, Polybase supports direct access to files stored in Azure File Share. Access is achieved through the creation of an external data source in SQL Server that points to the Azure File Share, and then creating an external table over the data in the external data source. The external table allows you to query the data in the Azure File Share as if it were a regular table in SQL Server.
Regards,
Umang Middha