1

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?

enter image description here

Blue Clouds
  • 7,295
  • 4
  • 71
  • 112

2 Answers2

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

wBob
  • 13,710
  • 3
  • 20
  • 37
0

It is true. PolyBase is not part of Azure SQL DB . And the document in your question is the latest.

Blue Clouds
  • 7,295
  • 4
  • 71
  • 112