Meta Collection and therefore Meta API possible?

[half token]

Hello guys,

do you know if it's possible to come up with a, let's call it meta/virtual collection, where I can alias the field last_name of collection A (original table) for example to name in collection B (meta/virtual)?

The use case for that is that we have several different customer databases containing the same data but every customer is having their own data schema and therefore different names for the same thing. We want to make the data of those different databases available to another application using a harmonized data schema. Basically like schema on read in a data lake set up for example.

Would something like this possible with Directus?

My best & thanks for your help
Stephan

[vale isle]

One possible solution:
I think you should look into Graphql for that purpose, as this has been designed for the purpose you have described.
Each data source is then considered to be a subgraph.
What you would do is then build a supergraph combining all subgraphs.
Check this article from the Apollo team
https://www.apollographql.com/blog/announcement/backend/the-supergraph-a-new-way-to-think-about-graphql/

That being said. As directus is connected to one single DB and not a multi DB system.
You may be able to Stich something together but with webhooks and flows but there are most probably better tools for your use case

[half token]

Thank you very much. That looks very interesting. Any ideas for an in-Directus solution?