Sharepoint to Blob Storage:Best Pratice

Question

Hello Team,

I am trying to read a file in List of values format from the SharePoint to want to copy the file to Blob Storage from data bricks.Is it possible.

Please advise and if any support documents Please advise me .

Regards
RK

Answer 1

Hello @Rohit Kulkarni ,

Welcome to the Microsoft Q&A platform.

Unfortunately, you cannot read Share point files in Azure Databricks.

Reason: Share point is not supported source in Azure Databricks.

For more details, refer to Azure Databricks - Data sources.

Are there any alternatives?

Yes, there are couples of alternatives to read share point files in Azure Databricks.

Option1: Copy files to Azure Storage and then mount the storage account to Azure Databricks and read from storage account.

You may checkout the SO thread addressing: Reading Excel file from Azure Databricks.

Option2: I found a third party articles which explains - Process & Analyze SharePoint Data in Azure Databricks.

Disclaimer: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.