I'm evaluating different BI solutions and I have a specific requirement.
Our setup has multiple DS with the same schema, e.g. Customer1DB, Customer2DB, etc.
Can multiple DBs be ingested in the same Superset dataset?
Historically Superset has not supported this. There are a few discussions of this on the project Github, here's one.
As of 4.0.0 you can enable the ENABLE_SUPERSET_META_DB
feature flag to try out this new feature, still in testing. It is documented here: https://superset.apache.org/docs/configuration/databases/#querying-across-databases
Two other workarounds for combining multiple DBs are:
Superset does support joining tables from the same database, they get combined into a new virtual dataset via Superset's SQL Lab. And it can connect to multiple databases and use them in different charts. It just can't join across them for a single chart.