cancel
Showing results for 
Search instead for 
Did you mean: 
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.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks app - permissions needed

SarahA
New Contributor II

Hi. I am trying to create a new databricks app and I get the following error

"Failed to create app [appname]. User does not have permission to grant resource sql-warehouse."

Can someone tell me what level of access I require in order to generate a data app?

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions

LRALVA
New Contributor III

Hi @SarahA ,

Requied Permissions to Create a Data AppYou'll need the following permissions in Databricks:

Permission Required Role / Grant Purpose
CAN MANAGE on the SQL WarehouseSQL Warehouse Admin or OwnerTo manage warehouse settings and assign it to the app.
CAN CREATE on the Catalog and SchemaData Engineer, Workspace Admin, or OwnerTo create app-related tables, views, or data models.
CAN MANAGE on the WorkspaceWorkspace AdminTo manage apps, permissions, and workspace-wide configurations.

Request Required Permissions from Admin:
Ask your Workspace Admin or SQL Warehouse Admin for the following grants:

GRANT USAGE, SELECT, MODIFY ON WAREHOUSE '<warehouse-name>' TO '<your-username>';
GRANT CREATE ON CATALOG '<catalog-name>' TO '<your-username>';

Additional Tips:
If your organization uses Unity Catalog, ensure you have the USE CATALOG and USE SCHEMA permissions for the target catalog/schema.
For improved flexibility, request CAN MANAGE on the SQL Warehouse if you need to modify warehouse settings

View solution in original post

1 REPLY 1

LRALVA
New Contributor III

Hi @SarahA ,

Requied Permissions to Create a Data AppYou'll need the following permissions in Databricks:

Permission Required Role / Grant Purpose
CAN MANAGE on the SQL WarehouseSQL Warehouse Admin or OwnerTo manage warehouse settings and assign it to the app.
CAN CREATE on the Catalog and SchemaData Engineer, Workspace Admin, or OwnerTo create app-related tables, views, or data models.
CAN MANAGE on the WorkspaceWorkspace AdminTo manage apps, permissions, and workspace-wide configurations.

Request Required Permissions from Admin:
Ask your Workspace Admin or SQL Warehouse Admin for the following grants:

GRANT USAGE, SELECT, MODIFY ON WAREHOUSE '<warehouse-name>' TO '<your-username>';
GRANT CREATE ON CATALOG '<catalog-name>' TO '<your-username>';

Additional Tips:
If your organization uses Unity Catalog, ensure you have the USE CATALOG and USE SCHEMA permissions for the target catalog/schema.
For improved flexibility, request CAN MANAGE on the SQL Warehouse if you need to modify warehouse settings