Share via

external data source - synapse workspace

arkiboys 9,711 Reputation points
2021-08-20T09:58:54.79+00:00

Hello,
There is an external data source created in the serverless sql pool.
How can I find out if this external data source is being used anywhere before deleting it?
Thank you

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
    2021-08-23T18:07:13.793+00:00

    Hello @arkiboys ,
    Thanks for the ask and using the Microsoft Q&A platform .

    If you query the sys.external_tables DMV and join it to sys.external_data_sources you can query and see if any external tables are using it before you delete.

    https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-external-data-sources-transact-sql?view=sql-server-ver15

    Please do let me know how it goes .
    Thanks
    Himanshu
    Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.