Can we access a file on SharePoint using external table on synapse datawarehouse?

Question

I have a requirement where I need to create an external table on Sysapse datawarehouse and this needs to point to a file on Sharepoint? The file on Sharepoint will be updated on realtime by users. If not what are the other alternatives?

Answer 1

Hello @Vivek Komarla Bhaskar ,

Thanks for the question and using MS Q&A platform.

Can an external table on synapse access files on ADLS Gen2 file share?

No, it is not supported data source.

In addition to @Nandan Hegde response - Currently, it is not possible to access a file on SharePoint using external table on synapse datawarehouse.

Note: CREATE EXTERNAL TABLE on top of the files placed on the data source with the same file format.

These are the supported data sources supported:

For more details, refer to Use external tables with Synapse SQL

Hope this will help. Please let us know if any further queries.

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

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of [Q&A Volunteer Moderators][50]

Answer 2

Hey,
Unfortunately you cannot read files in sharepoint via external tables in SQL DW.
Even if the file in Sharepoint is updated in real time by users, what is the frequnecy at which you want that data refreshed in your datawarehouse?