When I'm building a report in Google Data Studio from a MySQL source, I appear to only ever be able to work with 1 table per data source:
If I attempt to edit or change the datasource, I'm simply shown the single table that was selected when I created the datasource:
I need to join this table with another table. In this particular instance, I want to join with
customer_id to pull in customer data so that I can attach the customer's address to the Geo Map object on my report. You can see that object in the first screenshot.
Is there a way to join 2 tables and work with their data when building reports? The help docs aren't clear to me in this regard, and it appears to me that when you build a data source from an external database, you're forced to drill down all the way to the table level. Do I need to create 2 datasources to pull info from 2 different tables in the same database? If so, can they be joined so that data from both is available in the same report?