Hi, Yes I am using unity catalog.  

Permissions are as follows:

Catalog Privilages: 

Entra Group A = USE_CATALOG

Entra Group B = USE_CATALOG

Schema Privilages:

Entra Group A = USE_SCHEMA and SELECT on Schema A

Entra Group B = USE_SCHEMA and SELECT on Schema B 

External Location Privilages:

Entra Group A = READ_FILES on main table location

Entra Group B = READ_FILES on (the same) main table location

Then there is a SQL (serverless) Warehouse for each entra group

Entra Group A = Can Use on SQL Warehouse A

Entra Group B - Can Use on SQL Warehouse B

Steve belongs to both Entra group A and B, but when he uses SQL Warehouse A, I only want him to be able to see the data that is returned from the view created in Schema A.