databricks dashboards - how do share the dashboard to user with Limit the data access

[boopa45]

how do share the dashboard to user with Limit the data access without create a new dashboard with filler in source qry?

is there any other way?

example,

I have a dashboard it contains 3 location data example

India 

Canada

USA

I need to give limited acces to below users

India - User1

Canada - User2

USA - User3

if i give view access to User1 then user1 can view/work with India data only. other country data user2 should not have access. 

pls let me know.

[Coffee77]

Take a look at this docuumentation https://docs.databricks.com/aws/en/data-governance/unity-catalog/filters-and-masks/ Try to use "Row Filters" and/or "Dynamic Views"

[boopa45]

Hi @Coffee77 ,

any sample code or anything for ref? becuase i am new to databricks dashboard. 

Try to use "Row Filters" and/or "Dynamic Views" - we can shere on dashboard and based on the user it will be lmit the access right?

pls provide any ref dashboard or code or anything it would be grateful.

[Coffee77]

Take a look here on how to create "SQL Functions to manually apply as Row Filters" as it seems to be the most simple approach : https://docs.databricks.com/gcp/en/data-governance/unity-catalog/filters-and-masks/manually-apply#ro... https://docs.databricks.com/aws/en/data-governance/unity-catalog/abac/udf-best-practices 

After creating those SQL Functions, you should apply to tables or materialized views, in a way similar to this: https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/filters-and-masks/m... 

Then, select those tables or views from the dashboards data sources. The SQL function acting as "Row Filter" will filter rows automatically as per your desired parameters.

Partial sample here BUT use table in dashboard instead of DLT: https://medium.com/@aryan.sinanan/databricks-apply-row-filters-sql-or-py-dlt-4f369681e1fe