I’m having a dataset in bigquery with multiple tables with the same structure (each for one customer).
I would like to create and embed a report with a dynamic source that sets the table used as source for the report.
All table names are in dataset X and have a similar name customer_name_report_data.
How can I do this, couldn’t find any help online.
Did you find any solution for this? I have a similar requirement.