CODEWITHSUNDEEP
azure-sql-databaseazure-synapse
Kumaresh Roy
Kumaresh Roy

Reputation: 29

How to move sharepoint list or excel file to azure sql dw?

I want to copy data from sharepoint to microsoft azure sql DW using azure datafactory or alternative service. Can I do this. Please anyone help me with this.

Upvotes: 0

Views: 3296

Answers (1)

hiroki
hiroki

Reputation: 434

You can do this by setting up a data pipeline using Azure Data Factory to Azure blob storage. Afterwards you can use Azure's fast PolyBase technology to load the data from blob to your SQL Data Warehouse instance.

Can I ask how much data you intend on loading into the DW? Azure Data Warehouse is intended for use with at least terabyte level data up to petabyte compute and storage. I only ask because each SharePoint list or Excel file has a maximum of 2GB per file.

Upvotes: 2

Related Questions