Unable to import data from azure sql database/synapse dedicated sql pool using azure ai search

Question

I have first tried to connect to my synapse dedicated sql pool and tried to import data using azure ai search. I was able to validate connection and select my table. But when i go to next step to add cognitive skills, it validates and throws an error saying - Error Detecting index schema from data source

I then created an azure sql database allowing public access without any restrictions, created table and loaded data and tried to do the same but it didnt work either.

Then I tried to manually first add data source from here -

Im able to authenticate and connect to data but unable to save the data source because no matter what name I give, it says its already taken. I know these are two different issues, please help me connecting data in synapse dedicated sql pool to azure ai search, so that we can deploy llm model on top of it.

Answer 1

@suraj pawar vadeghar Thanks for asking question!

Error Detecting index schema from data source

This errors could be either because your search service is in private mode or because of the security configurations on your data sources (such as IP firewalls).

One good option is to use managed identities to connect to your data source.

There's articles showing how to do this for:

• Azure Storage
• Cosmos DB
• SQL Database

When you're using private endpoints, another good option is to create a shared private link between your data source and the search service.

Let me know.