Can I have multiple DB sources for the same dataset?


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 ingested all in the same dataset?

asked a year ago267 views
1 Answer
Accepted Answer

Short answer is YES, a dataset can use multiple data sources. One should simply do a full join that includes all records.

The UI only allows selecting existing fields to match them, so you can't use a condition like 1=1 Any help with that would be appreciated.

UPDATE: The matching rule doesn't really matter, FULL JOIN will always include all records from both sides.

UPDATE 2. Jan 2023 However, the result is a double set of columns, even if the two DBs and tables have identical column names."

Example of a dataset "merging" (or joining) different sources

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions