Source Azure SQL Database: You require an active Azure database to import data from the source file.

Destination data file in the Azure Data Storage: You should have a storage account and blob container for storing data from the Azure database.

This article will use the Azure Data Factory for populating (export) data from Azure SQL Database to the Azure blob storage. In the article, Azure Automation: Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage, we explored data importing using logic apps. There are different ways for data importing into the Azure database. You might also get data from the third party regularly for importing into the Azure database regularly. You might store these excel or other format files into the Azure blob storage. Azure SQL Database is a popular choice for storing structured data in the cloud. The source data can be in various formats such as JSON, CSV, ORC, TXT, EXCEL, Parquet. You might receive data in a specified format for importing it into database tables. DBA may import, export regularly within a different environment.

Get sdata tool