External table

Question

Hi, How to read data data from storage account using external table... How to add exact blob storage in location... Any step to get path or copy it

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

To read data from Azure Blob Storage using an external table, you can follow these steps:

Create an external table in your destination database that points to the data in Blob Storage. Here's a general structure for creating an external table

CREATE EXTERNAL TABLE [ExternalTableName] 
(
    [Column1] [datatype],
    [Column2] [datatype],
    ...
)
WITH 
(
    LOCATION = 'https://<storage-account-name>.blob.core.windows.net/<container>/<path-to-files>',
    DATA_SOURCE = [ExternalDataSourceName],
    FILE_FORMAT = [ExternalFileFormatName]
)

Create a new pipeline and add a Copy activity, and for the source, choose Azure SQL Database or Azure Synapse Analytics depending on where you created the external table

In the source dataset, you can now write a query that selects from your external table:

SELECT * FROM [ExternalTableName]

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful