How do I limit users to just the DBSQL lens of Databricks? I don't want them to have access to SQL endpoints or DE & ML lenses

Question

Here are the current options. I want to give the BI team only access to the S: SQL

Answer 1

Completely removing the other options is currently not available. However, you can lock them as shown in the picture.

1. Remove databricks-sql-access entitlement from default users group.
2. Create a new group called 'sql-users-only' and give them only this entitlement. (so they won't see workspace and they can't spin up endpoints)

Resources: Databricks provide a lot of control using ACLs. Access control overview You can restrict the dashboard viewing options as well. Dashboard permissions