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

Vivek Komarla Bhaskar 641 Reputation points

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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,102 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 59,326 Reputation points Microsoft Employee

    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 130616-image.png or upvote 130671-image.png 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]

1 additional answer

Sort by: Most helpful
  1. Nandan Hegde 22,721 Reputation points

    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?