0

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.

Improve this question

1 Answer 1

Reset to default
2

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

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Assuming this feature is not supported in either serverless / dedicated pool to directly access it from database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.