Hello @AE10
To allow users to view the dashboard without needing to sign in to Databricks, you can publish the dashboard with embedded credentials. This way, all viewers of the published dashboard can run queries using your credentials for data and compute. This allows users to see the dashboard even if they donโt have access to the originating workspace, underlying data, or SQL warehouse. However, be cautious as this might expose data to users who have not been granted direct access to it. https://docs.databricks.com/en/dashboards/index.html#publish-dashboard
To handle access for multiple users, each with a different dataset, you can use the following approach:
- Create a base dashboard: Design and publish a base dashboard within Databricks.
- Parameterize datasets: Use parameters in your SQL queries to dynamically adjust the dataset based on user input.
- Embed the dashboard: Embed the dashboard in your application using iframes.
- Pass parameters via URL: Use URL parameters to pass specific dataset identifiers for each user. This way, when a user accesses the dashboard, the appropriate dataset is loaded based on the parameters in the URL.
For example, you can use the following URL structure to pass parameters: <databricks-instance>/dashboardsv3/<dashboard-id>/published?o=<workspace-id>&f_<parameter-id>=<value>