Basically, Azure SQL database can only load files in Blob storage via BULK INSERT and OPENROWSET language features.
BULK INSERT dbo.test
WITH ( DATA_SOURCE = 'YourAzureBlobStorageAccount');
The way you have scripted is only available in SQL server 2016 and Azure SQL Data Warehouse now.
I hope this will help.
Want to become an Azure expert? join Azure Training now!!