Check for External Data Source If Exists

Category: azure sql data warehouse


Abhinav530 on Wed, 29 Jan 2020 19:09:30


I want to create a external data source, but before i do that i need to like if exists then not create. if does not exists then create.

what is the system object or the query that i can check if the data source already exists.




Nandan Hegde on Fri, 31 Jan 2020 06:53:45

Hello Abhinav,

You can execute the below query:

Select * from sys.external_data_sources

to get the list of external data source present.

So based on if not exists scenario , you can develop your code

NavtejSaini-MSFT on Fri, 31 Jan 2020 20:33:14

Hi Abhinav

Please let us know if you need further help with your question.

Navtej S