azure-search-openai-demo icon indicating copy to clipboard operation
azure-search-openai-demo copied to clipboard

Could this demo support Data Source from Azure SQL or Azure Cosmo DB?

Open teo-ma opened this issue 1 year ago • 1 comments

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [x] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

I saw the demo architecture on the readme,it can process data of Azure SQL and Cosmos DB with Azure Cognitive Search,but I can not see azure sql or cosmos service are created after I deployed this demo on Azure.Are there any ways to config the Azure SQL or Comos?So that we can search more data sources.

Thanks,

Teo


Thanks! We'll be in touch soon.

teo-ma avatar Mar 29 '23 07:03 teo-ma

We're trying to manage the complexity of the demo. Maybe as a starting point you could tweak it to do this once deployed? Assuming the individual pieces of text you have in CosmosDB or SQL aren't that long (i.e. don't need chunking), you could use Indexers, which will take care of connecting, indexing, etc. You could either configure the field mappings in the indexer to match the fields expected by the app, or change the app to use the field names created by the indexer.

Separately, you'd have to adjust the UX to display the citations differently since instead of PDFs you'd have database records, perhaps you can pull the record and show it as a list of fields in the citation window?

pablocastro avatar Mar 29 '23 15:03 pablocastro

Hello @pamelafox @pablocastro @teo-ma Is there any update on how to add CosmosDB data source to current repository ? Really appreciate your feedback. Best regards

quidba7 avatar Sep 28 '23 08:09 quidba7

I don't know of any PRs that add CosmosDB support to this repository, but there are other OpenAI samples out there that access CosmosDB. Here's an example from my colleague @sethjuarez who uses CosmosDB with PromptFlow in a demo: https://github.com/sethjuarez/contoso-trek

pamelafox avatar Sep 28 '23 19:09 pamelafox

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this issue will be closed.

github-actions[bot] avatar Jan 02 '24 01:01 github-actions[bot]