I have two synapse sql pools PoolA and PoolB
There is a table called Customers residing in Synpase SQL PoolA. Is there a way to access Customers table from Synapse SQL PoolB
I am exploring the option of create external data source, but couldn't the right syntax/ not sure if it supported.
Can any one help me with my issue.
Assuming it's a dedicated sql pool, unfortunately there is no current feature to query cross database ( via external tables)
You can query synapse table from Azure sql database via elastic query but cannot query any database from synapse