Combine data from Azure Synapse Analytics Dedicated sql pool and Serverless sql pool

Copper Contributor

Hi,

I have defined a view in a AzureSynapse serverless pool that fetches data with openrowset from cosmos db. I also have data in a table in a dedicated sql pool.

 

Is there a way I can do a sql query that would join these two objects?

 

Appreciate your help.

0 Replies