Search code examples
databricksacldatabricks-sqldbsql

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


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

Databricks lenses


Solution

  • 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)

    what users see

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