Polybase: Azure Sql DB cannot import blob storage

Question

Is it true that Azure SQL cannot import blob storage? (SQLDW can and also stand alone instance)

as given in this document, it cannot. But the document is from 2018. Has things changed after that?

Answer 1

Azure SQL Database does not have Polybase but it does have BULK INSERT, eg

BULK INSERT Product
FROM 'data/product.dat'
WITH ( DATA_SOURCE = 'MyAzureBlobStorageAccount');

See this question for more details and an example:

Create a table in Azure SQL Database from Blob Storage

Main page:

https://learn.microsoft.com/en-us/archive/blogs/sqlserverstorageengine/loading-files-from-azure-blob-storage-into-azure-sql-database