Check for External Data Source If Exists

Category: azure sql data warehouse

Question

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


Hello, 

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.

Thanks,

Rahul

Replies

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.

Thanks
Navtej S