Hello,
We are creating dashboards for internal users that show data usage for our clients. Each client env is a separate Databricks workspace that I’d have to connect to. I want a single dashboard with a parameter/filter for users to be able to toggle different client data. What is the best approach to do this? I don’t see a union option for data sources. Would love any feedback/suggestions!
Hi @rima.issa and welcome to the QuickSight community!
As databricks is still a fairly new addition to QuickSight, the supporting documentation is a bit light on instances like this.
You are correct that union’s are not fully supported in QS. One thing you could try though, after bringing in your datasets, creating an outer join to combine your datasets. This could allow the creation of a parameter to handle the separate clients as long as you have a field that can qualify them.
An alternate option, while this could be a bit more on the tedious side (depending on the number of clients), save your dashboard as a template, then you can use the template to create a new dashboard for each client. That way you only have to create the dashboard once but can utilize it across multiple client datasets.
Let me know if this could work for your case or if you have any additional questions!
1 Like
Hi @rima.issa - I am thinking ( however a poc needs to be done), can we create a master workspace and all client workspace require information can be shared to master workspace and then you can utilize master workspace for your quicksight reporting. Its like a common place where other workspace can share the data sharing so that you can do the reporting from a central place.
Regards - Sanjeeb
1 Like
Yeah this is probably the best approach since we can’t union in QuickSight. Thank you!