multi data source

[MasoumehSharifi-tim]

Can a single Wren v5 project contain metadata/models from multiple physical data sources (e.g. PostgreSQL + Snowflake + Oracle) and define relationships across them in one MDL? i mean one Wren project can model multiple databases simultaneously in a single semantic layer??????

[goldmedal]

No, Wren AI plans the SQL for a project in the same dialect. We don't have federated capabilities. You need to use a database (e.g., Trino, DuckDB, or DataFusion) that supports federated queries to connect to your data. Then, build a Wren AI project for it.