WrenAI how I switch different datasource?add multiple data sources？

Can I retain my current data source and add multiple data sources, and can multiple data sources be directly called by SQL.

Jul 22 '24 00:07 aiwenForGit

Hi @aiwenForGit, thanks for raising this. I've drafted a PR for this question, you can check "FAQ" part in this PR
https://github.com/Canner/WrenAI/pull/534

Jul 22 '24 08:07 onlyjackfrost

Hi @aiwenForGit Additionally, by integrating with Trino, you could aggregate multiple databases directly using SQL.

@himanshu634 is working on Trino integration at https://github.com/Canner/WrenAI/pull/535 . Feel free to leverage Trino after he finishes this PR.

Jul 22 '24 08:07 wwwy3y3

@aiwenForGit @wwwy3y3 I am working now on backend part. Will be ready for next release.

Jul 22 '24 09:07 himanshu634

Hi @aiwenForGit Additionally, by integrating with Trino, you could aggregate multiple databases directly using SQL.

@himanshu634 is working on Trino integration at #535 . Feel free to leverage Trino after he finishes this PR.

Hi @wwwy3y3, i want to know how to connect multiple data source using trino, since only 1 scheme and 1 catalog

Jan 06 '25 08:01 Herdanis

@Herdanis we don't support connecting to multiple catalogs at this point.

@himanshu634 , @onlyjackfrost what do you think changing the inputs to schemas input (format could be a comma separated string like catalog.schema, catalog2.schema2 ) ? So users could specify what catalog/schema they want to connect.

Jan 06 '25 09:01 wwwy3y3

okay, i just curious how to connect multiple data source using Trino, i hope it will be supported in the future update

Jan 06 '25 10:01 Herdanis