Azure File Storage から Azure SQL Server のテーブルに CSV ファイルをインポートするには、次の詳細な手順に従います。このプロセスでは通常、Azure Data Factory または Azure SQL Server Management Studio (SSMS) を使用します。以下では、両方の方法について概説します
方法 1: Azure Data Factory を使用する
https://sites.google.com/view/csv-file-from-azure/home
Method 1: Using Azure Data Factory
Create an Azure Data Factory Instance:
Log in to the Azure Portal.
Search for "Data Factory" and create a new Data Factory instance.
Create Linked Services:
In your Data Factory, go to the "Manage" tab.
Click on "Linked services" and create a new linked service for Azure File Storage.
Choose "Azure File Storage" and provide necessary details (e.g., account name, key).
Create another linked service for your Azure SQL Database.
Choose "Azure SQL Database" and enter connection details (e.g., server name, database name, authentication).
Create Datasets:
Go to the "Author" tab.
Create a new dataset for your CSV file:
Select "Azure File Storage" as the format and link it to the linked service created earlier. Specify the file path.
Create another dataset for your Azure SQL Table:
Select "Azure SQL Database" and link it to the SQL database linked service.
Create a Pipeline:
In the "Author" tab, create a new pipeline.
Drag the "Copy Data" activity into the pipeline.
Set the source to your CSV dataset and the sink to your SQL dataset.