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.