An user is assigned multiple groups but unable to query a data table

Administration & Architecture

Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.

Hi all,

I have a user who is enrolled in multiple groups within databricks but she is only able to query one of the query tables based on the original group assigned.

For example:

Group 1 will only be able to view data where [group] (column) = 'group1' (value)
Group 2 will only be able to view data where [group] (column) = 'group2' (value)

I have added this user in both group 1 and 2, so she should be able to query for both groups' data i.e. [group]= 'group1' or 'group2'. But she is only able to view 'group1' only.

Can someone advise? Thank you