Hi team, I'm investigating using data from 2 different data sources Is it possible to combine data from 2 data sources in a single visualization? Currently when I try, I get the error

Federation query contains table from external data source

Hi Jake, Yes, it's definitely possible to combine data from two different data sources in a single visualization. To make this work smoothly, you'll just need to ensure that both data schemas are correctly referenced and connected. A common approach is to use a shared key between the two datasets. For example, you could declare a primary key in Table A from Data Source 1, and then reference that key in Table B from Data Source 2, similar to how foreign keys work in relational databases. Once the relationship between the two tables is established, you'll be able to build a visualization that seamlessly brings in data from both sources.

Thanks @Moises Morales, maybe you could help me with this? I have a table Test which is coming from data source 2, and my table Property from data source 1. I've tried to join them using the Property ID which exists in both data sources I want to create a visualization which will show a table with the Property Name and Cost, but when I do this I get the error

Not a problem. In this case, you should be able to blend "Property ID" with any attribute or fact from the "Test" dataset. Please note that the main limitation of this feature is that both data sources (or datasets) must contain the attributes or facts you wish to use together in a single insight. Our Product team is aware of this constraint, but I’m happy to raise it with them again. Could you share more details about your use case? That would help us better understand your needs.

Thank you for sharing the documentation, the limitations are exactly what I am experiencing so it's good to see it's not an issue with my implementation. The use case here is that we have data in Google Analytics/Ads (such as impressions, clicks, etc) and data in Databricks (bookings, names, etc). We'd like to bring them both into GoodData to produce a single visualization that would replace a report

Thank you for sharing the use case. I will make sure to share it internally as product feedback, also depending as well on how critical this is, I recommend discussing it further with your Account Manager @Pablo Castro