question

arkiboys avatar image
0 Votes"
arkiboys asked arkiboys commented

external data source - synapse workspace

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered arkiboys commented

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://docs.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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi
How do I join them together?
select * from sys.external_tables --> returns 0 rows

select * from sys.external_data_sources --> returns 10 rows

Thank you

0 Votes 0 ·