Thank you for your feedback. Providing this functionality is on our backlog but there is no ETA we can share at this time. We have logged this request in the GitHub repository for the new open source storage emulator, Azurite. Please continue the discussion there: https://github.com/Azure/Azurite/issues/38. We will provide updates when they become available on this ask as well as in the GitHub repository. For any further questions, or to discuss your specific scenario, send us an email at azurestoragefeedback@microsoft.com.

If you configure an external datasource in SQL Server to point to blob storage (for bulk inserts of data to SQL from blob) you have to specify https in the url. This means we cannot test locally as emulator only allows http