Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can Fabric data warehouse be the external data source for Azure SQL database?

Hi All,   I am wondering whether I could create an external table in Azure SQL database which references Fabric data warehouse data.   Appreciate for any advice.
data warehouse
  • NandanHegde's avatar
    NandanHegde
    2 years ago

    Based on my understanding, that wont be possible.

    Reason: extrenal table /elastic queries within Azure SQL database only support SQL authentication and no AD based authentication.

     

    And fabric warehouse doesnt support SQL accounts.

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
2 years ago

Based on my understanding, that wont be possible.

Reason: extrenal table /elastic queries within Azure SQL database only support SQL authentication and no AD based authentication.

 

And fabric warehouse doesnt support SQL accounts.